Found the solution, in case anybody is interested:
The problem was only there when the view was used from AfO. The calculated column was a DECIMAL with two decimal places and the formula was:
(Numerator/Denominator)*100
When called from AfO it seems to perform the calculation in two stages
1. Numerator / Denominator - but the result is represented in the format of the column so 123 / 4567 = 0.026932 but, because of the two decimal places, gets represented as 0.02
2. Result of step 1 * 100. In this example 0.02 * 100 = 2.00
I got around it by changing the formula to (Numerator*100)/Denominator. So there is no chance to lose the decimal places:
1. 123*100 = 12300
2. 12300 / 4567 = 2.693234 but is represented as 2.69
Add comment