Formcalc help

[Former Community Member]

I'm trying to "wing it" to create a calculation. I have zero experience with this and noone to ask at work. This calculation is in a mechanical permit. The Total is determined by the number of feet x .05/ft. Minimum amount is $25. I have the fields of Items and a field of Totals. I have been able to get the calculation to work when the field has a number input, however I can't get the calculation to work when a "0" is input. Here is what I have so far.



if ((Items[36] * .05) < 25) then

Totals = 25

elseif ((Items[36] * .05) > 25) then

Totals = (Items[36] * .05)

elseif ((Items[36] * .05) < 0) then

Totals = 0

endif



I may not be going about it correctly, but this is what I've been able to come up with so far. Any help is greatly appreciated!

[_SekharN_]

Try this....you are just missing one '=' in the test condition on the second elseif.

if ((Items[36] * .05) < 25) then

Totals = 25

elseif ((Items[36] * .05) > 25) then

Totals = (Items[36] * .05)

elseif ((Items[36] * .05) <= 0) then

Totals = 0

endif

[Former Community Member]

Unfortunately that didn't work. I still have 25.00 in the Total column even when entering 0 as Item amount.

[Former Community Member]

I was able to get it to work...I switched the if with the last elseif.



if ((Items[36] * .05) <= 0) then

Totals = 0

elseif ((Items[36] * .05) > 25) then

Totals = (Items[36] * .05)

elseif ((Items[36] * .05) < 25) then

Totals = 25

endif

[Former Community Member]

I forgot...

Thank you, thank you, thank you!