Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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]))