Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
Please help me replicate the below SQL into SET analysis
hi
for starter set analysis works on fields and not expressions
so you'll need to have a date field for this
second assuming there are different STATUS_BEG_DATE AND STATUS_END_DATE for different rows in the table
set analysis isn't your solution
you should use an if statement instead
Count({if(Num(Monthend([Month Filter AP])) >=Num(Max(STATUS_BEG_DATE)) and Num(Monthend([Month Filter AP]))<=Num(Max(STATUS_END_DATE)),CASE_ID))