Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Totalling by account and currency — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Totalling by account and currency

Received Response
edited Sep 11, 2019 5:18AM in Oracle Analytics 4 comments


Totalling by account and currency


Good morning Guru's


I am building a template that should display segment1, segment4, segment5 (of the ccid), entered dr, entered cr and currency. It should give me totals for each group of segment1, segment4, segment5 and currency. The script has delivered the xml by G_1 as per attached xml. So if in each G_1 the segment1, segment4, segment5 and currency is the same I want the output to give me one record totalling the columns of entered dr and entered cr.


I have started off with the following in column 1 which is segment1.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!