Forum Documentation Showcase Pricing Learn more

Is it possible to use brackets in a calculation?

eg. Let’s say you wanted to express the progress of the month as a percentage of completion…

The calculation would be (Current Date - Month Start) / (Month End - Month Start).

:slightly_smiling:

1 Like

Will take a look at these - thanks!

The only viable solution I’ve found is to calculate subexpressions separately and keep them in the database (or in a hidden control if it’s in the same form you need them) and then use them to calculate say the division

Order of calculation is left to right with no operator precedence and no parentheses. It’s like having a single accumulator and various operations involving the accumulator and an operand

e.g.
5+6*3 is
5 = 5
5 +6 = 11
11 *3 = 33

and not 5+18=23

oops, fixed the original miscalculations (due to late hours probably)

That’s a bit crazy for such a simple thing