Calculate Percentage of Total Sales for each Sales Amount

building reports webintelligence
1

Trying to calculate the % of Total Sales for each Sales Amount. What formula do I use? Data sourced is Oracle.

fknaut :us: (BOB member since 2005-08-04)

2

The common function would be as you stated:

Percentage ([Total Sales] ForEach ([Sales Amount]))
-or-
Percentage ([Total Sales]) ForEach ([Sales Amount])

But, depending on the interaction of other columns in your report table, you may need to add additional calculation context to achieve the correct result.

datawizard (BOB member since 2015-01-20)