I have created a formula in my query which is :
Per unit price = sales value / sales qty.
I create another formula which is :
Stock value = Stock qty * Per unit price
Now when I run the report at Brand level , this is what I see
Brand Stock Value
ABC 11.09
Then when I drill down by Material , this is what I see
Brand Material Stock Value
ABC Mat1 10.8
Mat2 .10
Total 11.09
If you see that 10.8 + .10 IS NOT 11.09.
I see that the issue is with forumula collision. The formula collision is kept to " Result from this formula".
I am not sure how to correct this. Pls advice
Thanks
Hi,
If you want to do the calculation at material level, even though you are not displaying the report at other higher level (for ex: Brand level), the take the Global calculated KF as :
Stock value = (Stock qty * sales value / sales qty)*FV1.
Here FV! is a Formula varible with Replace ment path as the processing type and 0MATERIAL is the reference. And take attribute value = REference value(constant1) for this Variable.
With rgds,
Anil Kumar Sharma.P
That seems good but what if they drill down by someother characteristic like plant.
Thanks
Hi,
Still the calculation will be done at material level. and the summation of the CKF values of materials belongs to that plant will be displayed against that plant.
With rgds,
Anil Kumar Sharma .P
Hi BW,
Just go throw the below link, it might help you out to solve your issue.
http://help.sap.com/saphelp_nw04s/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm
Regards,
Shailaja
Hi ANil
I tried that formula variable but there i not effect. Could you please advice? I am totally stuck in this.
Thanks
check out if any condition is active.
There are no conditions