0
Where can I find proper syntax for nested formulas?
Example: result=((field 1-((field 1-2)*35%))/6
I've read the manual, not yet tried a tutorial. Thank you.
1 reply
-
Hi Doug,
You should see some examples in the manual, but you'll find more in the forum. For your specific example you would write it like this...
result := ('field 1' - ('field 1' - 2) * .35) / 6
You use := for assignment and = to test for equality. Field names that have 1 or more spaces require single quotes in formulas. The % symbol is the undocumented modulo operator. Hope that helps.
Content aside
- 4 yrs agoLast active
- 1Replies
- 528Views