How to create Dimention/Measure using variable in Expression

[TS08]

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

[vinieme12]

what is the variable definition ?? validate the variable $(V_Total On Hold Ageing)

Nothing wrong with the If() block