Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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)
i beleive something not right on the last formula, but not sure what is the issue, please help, thank you!!
Solved! Go to 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.
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.
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
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.
CH_WGHT_SYSTEM(by15%) = sum(Weight)*0.85
(Assume the weight drop 15%)
Thank you!
Hi Ericwhv,
what is the formula for the measure [CH_WGHT_SYSTEM(by15%)]?
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |