Order of Operations for Calculation

edg — Tue, 27 Jul 2021 15:31:33 GMT

I have a calculated field that produces a rate.

count({$<[Type] = {'C'}>} distinct [Number])

Sum(Total_Units)

I need the square root of the result. I've tried the following, including adding extra parenthesis so the rate is calculated before the sqrt. However, it's taking the square root of count({$<[Type] = {'C'}>} distinct [Number]) before dividing by Sum(Total_Units)).

Does anyone know how to get the total result and then take the square root?

sqrt(

(count({$<[Type] = {'C'}>} distinct [Number])

Sum(Total_Units))

)

Thank you in advance.

Re: Order of Operations for Calculation

Or — Tue, 27 Jul 2021 16:16:48 GMT

I'm not able to replicate your example...

In the above, the result of the final sqrt() formlua is correct - sqrt(4/400) = sqrt(0.01) = 0.1. If it were sqrt(4)/400 as you describe, the result would be 0.005 instead.

topic Order of Operations for Calculation in App Development

Order of Operations for Calculation

Re: Order of Operations for Calculation