i am trying to put a simple calculation with an if exception
if(Field2>Field3) then field1=(Field3-Field2)
I cannot get this basic thing to work and I am by no means a programmer.
Thansk for any help!
Solved! Go to Solution.
Views
Replies
Total Likes
If they are numeric fields the following FormCalc applies to field1.
// form1.page1.field1::calculate - (FormCalc, client)
if (field2 > field3) then
field3 - field2
endif
Views
Replies
Total Likes
Place this script (as FormCalc) in the script editor under calculate:
if (Field2 > Field3) then Sum (Field3 - Field2)
else null
endif
null can also be 0, or whatever calculation you want.
Views
Replies
Total Likes
If they are numeric fields the following FormCalc applies to field1.
// form1.page1.field1::calculate - (FormCalc, client)
if (field2 > field3) then
field3 - field2
endif
Views
Replies
Total Likes
Thank you! I finally got htis to work. I don't know if the issue was the fact I was trying to put this all on one lline. Very helpful though.
Views
Replies
Total Likes