BEx formula: Key figure divided by overall result
I need assistance on how to do the following BEx formula please?
I have "Sales" totals per "Dealers"
Overall Result = 21
How do I create the formula in BEx if I want to divide Sales for dealer A (10) with the 'Overall Result' Sales (21)? Note,
Your assistance will be appreciated.
Create a <b>Formula</b> below the <b>Sales Key Fig</b> and use the follwoing <b>formula</b>
<b>Sales / SUMGT ' Sales'</b>
<b>SUMGT</b> will be available in the <b>Data Functions</b>