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

COST = SUM(cost)

CH_WGHT_SYSTEM = SUM(Weight)

ACH_COST_KG = [COST]/[CH_WGHT_SYSTEM]
ACH_COST_KG(by15%) = DIVIDE([COST],[CH_WGHT_SYSTEM(by15%)])
COST_KG Difference(by15%) = [ACH_COST_KG(by15%)] - [ACH_COST_KG]
COST_KG change(by15%) = [COST_KG Difference(by15%)]/[ACH_COST_KG]

 

i beleive something not right on the last formula, but not sure what is the issue, please help, thank you!!

Need Help
  • Mikelytics's avatar
    Mikelytics
    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.

5 Replies

  • Mikelytics's avatar
    Mikelytics
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    Hi Ericwhv,

     

    what is the formula for the measure [CH_WGHT_SYSTEM(by15%)]?

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

    CH_WGHT_SYSTEM(by15%) = sum(Weight)*0.85
    (Assume the weight drop 15%)
    Thank you!

  • Mikelytics's avatar
    Mikelytics
    Icon for Resident Rockstar rankResident Rockstar
    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.

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

    Thank you Mikelytics 

    i have done this in Excel
    but similar to what you say, the result is very similar, 17.xx%
    i dont know if my logic is right or not, lol thank you