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

null
    • Sean
    • 3 yrs ago
    • Reported - view

    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

  • 3 yrs agoLast active
  • 1Replies
  • 527Views