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
Actual Cost = 0.
% = 0
% = 100
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..
Edited by: BRK on Jul 15, 2008 5:19 PM
Edited by: BRK on Jul 15, 2008 5:20 PM