Formula collision

[Former Member]

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

[Former Member]

There are no conditions

[Former Member]

Hi ANil

I tried that formula variable but there i not effect. Could you please advice? I am totally stuck in this.

Thanks

[former_member188325]

check out if any condition is active.

[Former Member]

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

[Former Member]

That seems good but what if they drill down by someother characteristic like plant.

Thanks

[Former Member]

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

[Former Member]

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