E1: RDA: Calculate Percentage of Total of Group (Doc ID 2123998.1)

Last updated on MAY 30, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.1 and later
Information in this document applies to any platform.

Goal

We want to display percentage of total sales for a group.

The report is grouped on LOB (line of business)

LOB ---- CAT ---- SALES ----- PERCENTAGE
-------------------------------------------
RT ---- 001 ----  5000 ----- 45.45%    (5000 / 11000 * 100) % of RT total
RT ---- 002 ----  4000 ----- 36.36%    (4000 / 11000 * 100)
RT ---- 003 ----  2000 ----- 18.18%    (2000 / 11000 * 100)
-------------------------------------------
TOTAL OF RT - 11000 ----- 61.11%    (11000 / 18000 * 100) % of grand total


FS ---- 004 ----  3500 ----- 50.00%    (3500 / 7000 * 100) % of FS total
FS ---- 005 ----  2000 ----- 28.57%    (2000 / 7000 * 100)
FS ---- 006 ----  1500 ----- 21.42%    (1500 / 7000 * 100
-------------------------------------------
TOTAL OF FS --  7000 ----- 38.88%    (7000 / 18000 * 100) % of grand total

GRAND TOTAL  18000                 (11000 + 7000)



How can this be done?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms