Forum Discussion

Ericwhv's avatar
Ericwhv
Icon for Helper II rankHelper II
3 years ago
Solved

Cost per KG changes is not working

Hi All thank you for reading this first i am working on some COST / KG changes in %, but not sure why the result is showing like below the result are all the same....   my formula as below...
  • Mikelytics's avatar
    3 years ago

    Thakn you, This is a general problem in what

    - you are calculating there. YOu calculate cost per kg

    - Then you reduce it by 15%

    - then you divide the two values above again -> in this scenario the result is everytime 17,65%

     

    If you calculate 0,85* 1,1765 then you get 1 again.

     

    SO it is not a technical problem its more the nature of your calculation. Do this in Excel and you should get the same results again. 

     

    Best regards

    Mikelytics

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.