PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

XSL function format-number() is not working when called from app engine

edited Mar 25, 2022 12:56PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 1 commentAnswered

Within the xml tags, we wanted to round the amount to two decimal places.

We had used the below code to round the amount since round() returns an integer value

 &sPaymentHeader = &sPaymentHeader | "<CtrlSum><xsl:value-of select=""round(100*$sumAmt) div 100""/></CtrlSum>" | Char(10) | Char(13);

However, a float values is returned on using this.

For example if the expected outcome is 11.67, the above statement returns 11.699999

We noticed that this occurs when any arithmetic function is used like sum() div() etc.

To overcome this, we tried using fromat-number(). But this has no effect.


Can you please review and suggest an alternative?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center