Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need an expression that will do a count when a flag is not equal to true and a date is equal to a variable value.
I can get it to work in parts but not all together. Really not sure what I am missing.
Count({1} If( islegacy-={'TRUE'} AND ENROLLFISCMTH = {'=$(vTodayFISCMTH)'} ,acct_id))
This is along the lines of what I have been trying with no luck.
Count({<islegacy-={'TRUE'} ,ENROLLFISCMTH = {'=$(vTodayFISCMTH)'}>} acct_id)
Thank you.
Your expression is working for the legacy flag portion but it is not filtering based on the month.
I have 800 records that are not legacy and only 3 in the current month. But this expression is returning the full 800.
I have verified the actual data and the value in the variable and they are both 2019002 for those 3 records. None of the others should be counted as they are prior to this month.