Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BEx formula: Key figure divided by overall result

Good afternoon

I need assistance on how to do the following BEx formula please?

I have "Sales" totals per "Dealers"

example:

Dealer: Sales

A 10

B 5

C 6

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.

Cj Faurie

Former Member
Former Member replied

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>

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question