PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

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

User_TODS2
User_TODS2 Posts: 4 Blue Ribbon
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:

Answers

  • Nicole V-Oracle
    Nicole V-Oracle Posts: 1,474 MOSC Community Manager

    Hello,

    Due to the nature of this question/issue, we encourage input from the community network about how others have solved this business need.

    Best regards

    Nicole Oracle

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center