Hiding Value For key Figure

[Former Member]

Hi:

I have a report which shows Plan Qty, Plan Price, Contract Qty and Contract price.

In some cases we have contracts with the Qty but no Net price. I want to hide the the contract qty and Contract net price If there is no Contract net value. How this can be accomplished?

Thanks

[former_member188975 · Accepted solution]

Hi Sunil,

You can try to do this with a formula for Contract Qty and Contract Net Price in which you compare the value of Net Price. Something like:

(Net Price ==0)*(Contract Qty * 0)+(Net Price <>0)*(Contract Qty *1)

Hope this helps...

[Former Member · Accepted solution]

Bhanu:

Do i have to create a seperate formula for this to work?

[former_member188975 · Accepted solution]

Yes, pull in all the key figures you need into the query because you will need them to create the formulas. Then you can hide the original and let the formula be displayed.

Hope this helps...

[Former Member]

You can always get the right answer from Bhanu. It's IF THEN ELSE cocepts. Please go to the following link.

http://help.sap.com/saphelp_nw04/helpdata/en/23/17f13a2f160f28e10000000a114084/content.htm

Regards:

Buddhi