Water Cooler

[RishabhTFC]

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))
Model-A	10	8	48	0	-46
Model-B	60	116	205	0	-261
Model-C	775	456	1832	0	-1513
Model-D	25	2	2	8	13
Model-E	52	59	2303	0	-2303
Model-F	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

[Gysbert_Wassenaar]

Perhaps like this:

RangeMax(0,(Sum(Forecast) - sum(Billing Quantity)) - (sum(Forecast_2)+sum(Left_Quantity)))

[RishabhTFC]

no its not working

[RishabhTFC]

hello @Gysbert_Wassenaar  your Expression works but only in Table form when I kept it in KPI then value gives 0

[sunny_talwar · Accepted solution]

How about this

Sum(Aggr(
  RangeMax(0, (Sum(Forecast) - Sum(Billing Quantity)) - (Sum(Forecast_2)+Sum(Left_Quantity)))
, [Model Number]))