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
please post sample data with input values and the complete expected result.
thanks
regards
Marco
please create a complete input/output specification instead of opening new threads for the same question.
thanks
regards
Marco