Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can someone please help me with this nested if condition in the script.
I want to categorize these days into four sub groups.
i.e., >10 , >31, >61, >91
I wrote the if condition but its failing in some cases.
if([Days Past Due] >91, '>91',
if([Days Past Due] ,'>61',
if([Days Past Due] ,'>31',
if([Days Past Due] >10 ,'>10',null())))) as [Days Past Due Range],
Regards,
Sachin
Try:
if([Days Past Due] >91, '>91',
if([Days Past Due] > 61,'>61',
if([Days Past Due] > 31,'>31',
if([Days Past Due] >10 ,'>10',Null())))) as [Days Past Due Range],
please create a complete input/output specification instead of opening new threads for the same question.
thanks
regards
Marco