BI Publisher (MOSC)

MOSC Banner

Disable the scientif format for big number inside variable (ex: 1,1222222 E6)

edited Jul 17, 2013 6:31AM in BI Publisher (MOSC) 3 commentsAnswered ✓
Hello,

I have defined a variable V_SUM which get the incremental sum of the fiel FIELD:

<?xdoxslt:set_variable($_XDOCTX, ‘V_SUM’, number(FIELD)+number(xdoxslt:get_variable($_XDOCTX, ‘V_SUM’)))?>

When I display the content of my variable, values below 1 000 000 are OK, but values greater than 1 000 000 are displayed in scientific format (ex: 1,1222222 E6)

I tried forcing the format with the below code, but I still get the scientific format.

<?format-number:xdoxslt:get_variable($_XDOCTX, 'V_SUM);'999G999'?> or <?format-number:xdoxslt:get_variable($_XDOCTX, 'V_SUM);'999G999G999'?>

Does anyone have an idea about how to get always the full number instead of scientific format?

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