This space is for everyone to ask questions related to the Community Platform. It's a space for us to get to know each other and have some fun! Come in and gather around the Water Cooler!
Hi Can someone helpp me to get the output in KPI which contains the sum of only positive numbers. of 6 th Column
Model Number 
Forecast 
Billing Quantity 
Forecast_2 
Left Quantity

(Sum(Forecast)  sum(Billing Quantity))  (sum(Forecast_2)+sum(Left_Quantity))  
ModelA  10  8  48  0  46  
ModelB  60  116  205  0  261  
ModelC  775  456  1832  0  1513  
ModelD  25  2  2  8  13  
ModelE  52  59  2303  0  2303  
ModelF  80  10  20  3  47 
Can we get the sum of only positive value of following expression in KPI: i.e. 13+47 = 60
(Sum(Forecast)  sum(Billing Quantity))  (sum(Forecast_2)+sum(Left_Quantity))
Thnaks
Rishabh
How about this
Sum(Aggr(
RangeMax(0, (Sum(Forecast)  Sum(Billing Quantity))  (Sum(Forecast_2)+Sum(Left_Quantity)))
, [Model Number]))
Perhaps like this:
RangeMax(0,(Sum(Forecast)  sum(Billing Quantity))  (sum(Forecast_2)+sum(Left_Quantity)))
no its not working
hello @Gysbert_Wassenaar your Expression works but only in Table form when I kept it in KPI then value gives 0
How about this
Sum(Aggr(
RangeMax(0, (Sum(Forecast)  Sum(Billing Quantity))  (Sum(Forecast_2)+Sum(Left_Quantity)))
, [Model Number]))