Expand my Community achievements bar.

July 31st AEM Gems Webinar: Elevate your AEM development to master the integration of private GitHub repositories within AEM Cloud Manager.

## 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!
4 Replies

Level 5
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!