Key Figure Scheme Formula
I have read all the posts related to key figure scheme but unable to get the solution. My requirement is to calculate cost based on volume that is i want to calculate per MT cost. For example : Sales volume/sale quantity, cogs/sales quantity. In short I want to divided all the revenue and cost by volume and show it in separate column. Through KFS i am unable to do. So if I use User Exit COPA0005 then how would i achieve the result.
Ajay Maheshwari SAP Trainer replied
Ideally, you can add a row under each row and insert the formula to divide by Volume
Copy this report into another report, insert these rows and hide the Original rows. So you have only % in that report
For the formula rows you can choose "No Cell Processing" so that the formula does not apply to those rows