Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts, could any one help with my attached script error. all i am trying to do apply color coading based on percentage levels for
"Early arrears" and "late arrears" ,
Details: Straight table dimention is "Arrearsprofile" , expression is sum(Current balance)
Backend script Dimension caluculated like this
IF (ArrearsBand > 0 AND ArrearsBand <=3 ,'Early Arrears',
IF (ArrearsBand >3 ,'Late Arrears',)) AS 'ArrearsProfile',
Many thanks Anil and Vineeth, got the result. 🙂
Hi, i've modified the expression in post above, try and check this should be all you need
Thanks for you help Vineeth