Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
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)
Thanks a lot its working like a charm
Awesome
I am glad it worked. I would suggest closing this thread by marking the correct answer.
Best,
Sunny