Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.