BI Publisher (MOSC)

MOSC Banner

Total the amount within a group and don't include duplicate values

edited Dec 20, 2019 4:00AM in BI Publisher (MOSC) 1 commentAnswered

I'm creating a report in Oracle 12c BI Publisher using a RTF Template and having an issue which is I want a grand total in the bottom of the report which will compute all the amount but will not include the duplicate value. For example I have a table consists of:

IDName
Transaction_NO1Amount1Transaction_No2Transaction_No3
IDNameTransaction_No1Amount1Transaction_No2Amount2
1A1111

12,000

12123,000
2A111214,00012123,000
3A111316,00012123,000
4B111411,00012211,000
SubTotal80,000

You can see above that the 121 in column Transaction_No2 has a multiple values but different transaction_no1 so that it Computes all the amount in amount2

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