Conditions in count not working

[#1]

Good day,

I tried this piece of code, and my filters are not working, please assist:

count(if(PRODUCT_CODE='MLOAN' and REG_LAST_3MONTHS_IND='Y' and match(MLOANS_BANDS_CODE,'A','B','C','D','E','F'),FINAL_ML_AMT))

[sunny_talwar]

Try this with set analysis may be:

=Count({<PRODUCT_CODE = {'MLOAN'}, REG_LAST_3MONTHS_IND = {'Y'}, MLOANS_BANDS_CODE = {'A', 'B', 'C', 'D', 'E', 'F'}>} FINAL_ML_AMT)

[#3]

Thanks a lot its working like a charm

[sunny_talwar]

Awesome

I am glad it worked. I would suggest closing this thread by marking the correct answer.

Best,

Sunny