Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I don't get what is wrong is wrong with this expression, the max(TS_STAT) aggregated for each TS_NO, if is greater than 3050 and less than 3200 then TS_NO should be counted.
=Count({<TS_NO={"=(Max(TS_STAT))>= 3050 < 3200"}, TS_DEL_MONTH= >} Distinct TS_NO)
TS_NO | MONTH | TS_DEL_MONTH | TS_STAT |
1499973 | Jan-2020 | Dec-2019 | 3300 |
1499973 | Dec-2019 | Nov-2019 | 3200 |
1499973 | Nov-2019 | Oct-2019 | 3050 |
1499973 | Oct-2019 | Sep-2019 | 2800 |
Logic: If I select Oct-2019 and Nov-2019, the max would be 3050 for the TS_NO, hence TS_NO should be counted, but if don't select anything, max would be 3300 and hence TS_NO should not be counted.
Here if I remove less than 3200, then the TS_NO is counted.
Regards,
Vinay
Try this,
=Count({<TS_NO={"=If(Max(TS_STAT)>= 3050 and Mac(TS_STAT)<3200,TS_NO)"}, TS_DEL_MONTH= >} Distinct TS_NO)
Try this,
=Count({<TS_NO={"=If(Max(TS_STAT)>= 3050 and Mac(TS_STAT)<3200,TS_NO)"}, TS_DEL_MONTH= >} Distinct TS_NO)