Skip to Content
0
Former Member
Jul 15, 2008 at 03:15 PM

Reg - If ELSE usage in BEX Querry

9 Views

Hi,

I have to implement below simple business logic at Querry level

Var Plan/Actual Cost Percent % =

If Plan Cost NE 0:

% = (Actual Cost - Plan Cost ) * 100 / Plan Cost

Else

Actual Cost = 0.

% = 0

Else

% = 100

endif.

and I have created calculated keyfigure as below

( 'Planned costs' NE 0 ) * 'Actual costs' % 'Planned costs' + ( ( 'Actual costs' == 0 ) AND ( 'Planned costs' == 0 ) ) * 0 + ( ( 'Actual costs' NE 0 ) AND ( 'Planned costs' == 0 ) ) * 100

I know that we need not validate again planned costs in else part but still as it was not working correctly just modified after refering sap help but still it is not giving expected result so can you please have a look at it and let me know what i am missing here??

Thanks for your valuable time..

BRK

Edited by: BRK on Jul 15, 2008 5:19 PM

Edited by: BRK on Jul 15, 2008 5:20 PM