Cost per KG changes is not working

[Ericwhv]

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!!

[mangaus1111]

Hi @Ericwhv ,

see my sample model here for calculating percentage. I hope it helps.

https://1drv.ms/u/s!Aj45jbu0mDVJiyzIDA3ZUs-mwqyq?e=JbewcX

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

[Ericwhv]

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

[Mikelytics · Accepted solution]

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]

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

[Mikelytics]

Hi Ericwhv,

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