Forum Discussion
SUM DOESNT WORK PROPERLY
Hi,
I have an issue about how to calculate the total of a column, if you see i am using a "what if parameter" to calculate optimal inventory based on the Turnover Target by ABC Class, the formula behind it is:
OptimalInventory =<Usage Amount> / <Turnover Target (A,B,C)>
This is the formula for the Optimal Inventory:
1_OptimalInventory = SWITCH(TRUE()
, min('Optimal Inventory Param'[ABC Class]) ="A" , SUM('Optimal Inventory Param'[Usage Amount]) / 'Turnover Target A'[Turnover Target A Value]
, min('Optimal Inventory Param'[ABC Class] ) ="B" , SUM('Optimal Inventory Param'[Usage Amount]) / 'Turnover Target B'[Turnover Target B Value]
, min('Optimal Inventory Param'[ABC Class] ) ="C" , SUM('Optimal Inventory Param'[Usage Amount]) / 'Turnover Target C'[Turnover Target C Value]
, 0 )
But if you see in the total is: 70,690,614.00
53,643,182 + 6,806,314 + 4,558,641 = 65,008,136
The total line is showing a wrong number.
Can anyone help me?
Thanks.
Regards,
Cesar
1 Reply
- v-qiuyu-msft
Community Support
Hi CESARADVINCULA,
Please share the pbix file with us. Do remove sensitive data before sharing.
Best Regards,
Qiuyun Yu