Skip to Content
0
Former Member
Jun 27, 2007 at 08:35 PM

Bex limitation ?? Not able to get hold of Sum of a formula

40 Views

Hi Experts,

I have one issue for which it seems this is BEx limitation...?? plz prove me wrong because its sounds so simple that Bex should be able to handle it...

Heres the scenario :

I have 4 columns in the report ->

Demand : coming from cube

Forecast : coming from cube

Demand else forecast : formula ( if demand not equal to 0, take demand else take forecast.

Weight Factor : demand else forecast / SUMCT ( demand else forecast )

<b>Actual report :</b>

Demand, Forecast, Demand else forecast, Weight Factor

100 0 100 .5

0 50 50 .25

100 200 100 .5

0 0 0 0

-


200 250 200

-


<b> Correct/ Required Report :</b>

Demand, Forecast, Demand else forecast, Weight Factor

100 0 100 .4

0 50 50 .2

100 200 100 .4

0 0 0 0

-


200 250 250

-


Issue is with Result Row only of Demand Else Forecast...individual rows are coming correct..

Questions:

<b>1) Why result of demand else forecast is coming as 200 instaed of 250??</b>

((( I think becasue its applying formula to result rows also... so its picking up demand always...as some demand would be there...)

<b>2) How to get hold of correct sum of demand else forecast and thus weight factor would be correct...??</b>

(( Changing property of a Demand else forecast would NOT work as thats just for displaying purpose....even if I change its property it would display correct sum but would not use that figure in actual weight factor calculation - i have already tried out))

<b>3) How formula Collision works???</b>

(( Is it with just two structures?? how to utilize that in this scenario??... I have read SAP help but trying to use that here..but of no use..))

Plz help me - I dont want to tell users that I have to write VB code for this simple thing...

All help/ideas appreciated..

Thanks

Gaurav

Message was edited by:

Gaurav

Message was edited by:

Gaurav