Skip to main content
Participant
Nov 22, 2022 6:20 PM UTC
Question

Multiply 2 field by a number and each other

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 is closed to new replies. Start a new post to keep the conversation going.

1 reply

Bernd Alheit
Community Expert
Community Expert
Nov 23, 2022 5:51 AM UTC

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

X_35 * 35 * X

Translate