Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to create ageing buckets based on ageing (Days) Variable but getting error. Please advise what exactly I am doing wrong.
I have tried creating DIMENSION as well as MEASURE using the same expression
--> Expression:
=If($(V_Total On Hold Ageing)=0,'1) No Ageing',
if($(V_Total On Hold Ageing)<= 30, '2) 1-30 Days',
if($(V_Total On Hold Ageing)<= 60, '3) 31-60 Days',
if($(V_Total On Hold Ageing)<= 90, '4) 61-90 Days',
if($(V_Total On Hold Ageing)<= 120, '5) 91-120 Days',
if($(V_Total On Hold Ageing)<= 150, '6) 121-150 Days',
if($(V_Total On Hold Ageing)<= 180, '7) 151-180 Days',
'8) > 180 Days')))))))
--> Error Message:
Error in expression as ')'
Let me know if you like to see the Variable expression also.
Thanks
TS
what is the variable definition ?? validate the variable $(V_Total On Hold Ageing)
Nothing wrong with the If() block