BI Publisher (MOSC)

MOSC Banner

Get the total of two columns with number format using rtf template

edited Jul 16, 2019 10:18PM in BI Publisher (MOSC) 9 comments

Hi,

I have a report that contains two columns which is I want to get the total using the rtf. Now I tried the <?xdofx: to_number(VATABLE,'#,##0.00')+to_number(VAT_EXEMPT_SALES,'#,##0.00')?>

but it returned me a NaN. Then I tried the <?xdofx: to_number(VATABLE)+to_number(VAT_EXEMPT_SALES)?> but the result that I excpected is wrong. For example,

I have two columns,

Column1       Column21423             1555

Then I export the xml in the bi publisher using the microsoft word.

Now I want is to get the total of the two columns,

I tried the

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