Set Less Than Not working

[baliyan_vinay]

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

@kaushiknsolanki 

[kaushiknsolanki · Accepted solution]

Try this,

=Count({<TS_NO={"=If(Max(TS_STAT)>= 3050 and Mac(TS_STAT)<3200,TS_NO)"}, TS_DEL_MONTH= >} Distinct TS_NO)