Forum Discussion

CESARADVINCULA's avatar
CESARADVINCULA
Frequent Visitor
8 years ago

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