Math calculations in magic formulas

i need to calculate relative gain difference using two values. Usually there should be following formula:

(x / y - 1 )*100

because in magic formulas u cant use “()” i cannt receive needed result.
for example:
(3/5 - 1)*100 = -40 (%)

in magic formulas i can have only:
3/5 - 1*100
which is different result

are there any workarounds?
thanks in advance

And it loos like i cant store part of this formula as a record in database because value of each variable is dynamical based on relative date.

The formula should be:


1 Like

Hi, Ben,
this is great
thanks a lot

looks like behind the business logic, lost some math :wink: