Where can I find proper syntax for nested formulas?

Ninox Profile

Example: result=((field 1-((field 1-2)*35%))/6

I've read the manual, not yet tried a tutorial. Thank you.

Ninox Profile

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.

Reply