Decimal places in calculation

Summary:

Rounding and scaling issue in calculation.

Content (please ensure you mask any confidential information):

I have a question on scaled value used in IF condition comparison:

The grid level setting "Use scaled/rounded value" is True.

The scaled value does not get used in the IF expression evaluation.

Original database value

A = -6417419.04

B = -67553.659999982

Scaled value by -1000000 (represented in 5 decimal places)

A = 6.41742

B= 0.06755

Formula = ( A-B ) / B = 94.00251665433013

9 decimal places in Percentage value = 9400.25166543301%

But I am getting 9399.735528766% because it is considering 9 decimal places number for calculation as:

(6.41741904 - 0.067553659999982) / 0.067553659999982

Version (include the version you are using, if applicable):

Service: Enterprise Performance Management Enterprise Cloud