xMII format() uses round-half-up algorithm. We need scientific round-all-up

[Former Member]

Hi,

In xMII built-in function, format()

uses the round-half-up algorithm for

rounding. For instance, 96.8855 rounds

up to 96.886 and 96.8865 rounds down to 96.886 for 3 decimal.

This type of round-half-up algorithm

usually is used in Banker's Industry.

Is there any way in xMII to provide

the scientific round-full-up algorithm?

For instance, 96.8855 rounds up to 96.886

and 96.8865 rounds up to 96.887.

Appreciate for prompt response as the

project is in the stage of final

validation. We need to find the

workaround ASAP.

Thanks a lot,

Leey

[jcgood25]

round(96.8865 * 1000.0) / 1000.0

[Former Member]

Jeremy,

Thank you so much for quick response. It works.

Leey

[jcgood25]

Leey,

Glad to hear it's working for you, and it is also good to see you here on the forums!

Regards,

Jeremy