Level 1

0% to

Level 2

Tip /

to gain points, level up, and earn exciting badges like the new
Mission!

View all

# Adobe LiveCycle (Archived)

## Formcalc help

Not applicable
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!
0 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

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

Not applicable
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

Not applicable
I forgot...

Thank you, thank you, thank you!