BI Publisher (MOSC)

MOSC Banner

Adding two tags as a total in bip template

edited Apr 27, 2022 5:38AM in BI Publisher (MOSC) 2 commentsAnswered

Hi guru's

I need a bit of assistance please. This is the xml:

I want to total tags EXTENDED_AMOUNT which lies in 3 separate G_3's.... and it's related OPENING_BALANCE which lies in G_1.

Now I know in this case the opening balance is 0, but I have others which are not 0. I want to add this at the end of the report for each customer as a total of opening balance plus movement. OH I I also need to have a way of if the total is below 0 I must pop it into the CREDIT side of the report and if it is 0 and more than 0 then I must pop it into the DEBIT side of the report.

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