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
Then when I drill down by Material , this is what I see
Brand Material Stock Value
ABC Mat1 10.8
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
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.
Anil Kumar Sharma.P
Just go throw the below link, it might help you out to solve your issue.