I’m trying to calculate tonnage for a client but I’m not sure how to set up one of the fields.
The formula is this:
Width x length / depth x material poundage / 2,000 = tonnage needed
I got it to work BUT for the depth there’s an additional calculation…
12" thick, do not divide
6" thick, divide by 2
4" thick, divide by 3
3" thick, divide by 4
2" thick, divide by 6
1" thick, divide by 12
I’m not sure how to do this???
@dahn if you use a Radio or Select field to allow the user to select the depth, you could make this work by enabling the “Show Values” option.
You’d then configure the following choices for that field
Label | Value
12" thick | 1
6" thick | 2
4" thick | 3
3" thick | 4
2" thick | 6
1" thick | 12
Finally, in the calculation you are creating use the :value merge tag modifier for your division.
Oh my gosh! That’s brilliant. I don’t know why I didn’t think of that. 
THANK YOU!