Skip to main content
Participant
November 22, 2022
Question

Multiply 2 field by a number and each other

  • November 22, 2022
  • 1 reply
  • 293 views

I have a form that I would like a formula for. The scenario is:

Security guards are booked 1:50 at $35 an hour. I would like to put the number of hours into field 35_X and then put the number of guards into field X. I would then like for the following to calculate into field Total_6:

 

(35_X * $35)*X

 

So, # of hours * rate ($35) * # of guards

Please help!

 

Thanks,

Jessica

This topic has been closed for replies.

1 reply

Bernd Alheit
Community Expert
Community Expert
November 23, 2022

Change the name of the field 35_X to X_35 and use as simplified field notation:

X_35 * 35 * X