Rounding Error?

[Anonymous]

I created the below measures.

Measure A = sum([sales 1]) / sum([Area 1]). 

Measure B = sum([sales 2]) / sum([Area 2]). 

Maximum = if( Measure A > Measure B, Measure A, Measure B)

Difference = Maximum - Measure A

Now, if Measure A > Measure B. Maximum returns the value measure A. But value of 'Difference' is not zero, i.e. 6e-13.

Why there is a difference after putting the numbers into the if statement?

[Anonymous]

Hi @Anonymous ,

Failed to reproduce the scenario, please show some sample data.

Best Regards,

Jay

[amitchandak]

@Anonymous , Limit that to two or three decimal places.

Also, make sure it is decimal type nor scientific

[Anonymous]

Thanks for your suggestion. However, it does not help. My question is why there is a tiny different after I put the value into the 'if' funtion even though the measures inside the 'if' and without 'if' are the same function. All the measures are in decimal.