Updated doc: Math Expressions

Feedback welcome!

5 Likes

Thank you Steve for update!

I still struggling with Division involving number , decimal , percent etc. it could be potentially bug though. I placed exactly same formula in initial value and virtual column . Both returns different number. I will try to reproduce.

When the complex division calculates for instance , division calculation is nested within another cal and each element is either number or decimals , and proper integer or decimal number involved, it is difficult
To expect the return .

It should be reasonable if number devised by number should return decimals rather than always returning number.

1 Like

Looks great, Steve!

In general I agree. I feel that division should always run as if the number are already Decimals. If being put into a Number column, it should just truncate the decimal portion (not round). But at the same time, I imagine changing this behavior will lead to other issues.

1 Like

I agree, but I just document the behavior. I have no power to change it.

1 Like