Formula in BEx

[Former Member]

Good afternoon.

How do I do the following formula in Bex?

Key figure: Sales to target = 75%

Key figure: Retail Sales = R250.00

If 'Sales to target' is =<100% then mulltiply 'Retail Sales' with 2.35%.

I just do not get it the same as in Excel.

Thanks yet again.

Cornelius Faurie

[Former Member · Accepted solution]

(Sales to Target =< 100) * Retail Sales * 2.35 / 100

[Former Member]

Thanks for the information. have a lovely weekend. Cornelius

[Former Member]

I do understand the first resolution, but 1) how will I handle a formula where several measures apply? Example:

Key figure: Sales to target = 75%

Key figure: Retail Sales = R250.00

Measure: If 'Sales to target' >= 80% do a payout of 2%

Measure: >= 'Sales to target' 70% do a payout of 1.7%

Measure: >= 'Sales to target' 60% do a payout of 1.4%

2) I need to bring the measure and Payout into BW as well via flat files, what should the file format look like and how do I apply?

Thaks yet again

Cornelius

[Former Member]

1) You can handle various measures just by adding it. i.e.

((Sales to target >= 80) * Retail Sales * 2/100 ) + ((80 > Sales to Target >= 70) * Retail Sales * 1.7/100) + (......) +.....so on

2) I did not understand this. You can just bring the values via flat-file or you can calculate the same in UR.

[Former Member]

Hello Cornelius,

In a formula (x>1)*2, if (x>1) condition is met will yield 1, result = 2 or else 0.

So the formula for your examples would be

((sales to target >=80)0.2 + (sales to target >=70)0.16 +(sales to target >=60)0.14)payout

Since at any given instance only one condition is met so you will get the result.

coming to bringing the values thru flat file, make sure the order in which keyfigures are in cube, follow the same order in flat file, mapping for the characteristics should be done correctly in the transfer rules.

*assign points if useful*

Peter R