Rounding of 6 decimals value to 2 decimals

[nanda_veera]

Hi,

We have a CKF which is multiplication of a RKF (2 decimals) and a mapping value (which will have 4 decimals). So, the CKF is getting a value with 6 decimals. We wanted to round the 6 decimals to 2 decimals in the CKF.

Please advise if anybody had similar kind of issue earlier.

Couple of examples:

0.444445          Expected: 0.45

1.547449          Expected: 1.55

Best Regards,

Nanda.

[Former Member · Accepted solution]

Nanda,

Try in  CKF properties display Decimal Places as 0.00.

This will round off to 2 decimal digits.

Regards,

Venkatesh

[nanda_veera · Accepted solution]

It didn't worked in certain scenarios Rakesh.

I have resolved this by using the magic number '4445' (decimal 4 digits after multiplied by 100) with below expression

((((FRAC ('CKF' * 100)) * 10000) >= 4445) + TRUNC(('CKF' * 100)))/100