Variable not working

[krish2459]

Hi,

I'm using the beow variable in as dimension but I'm ot getting any output.

Varaible:

V_Week_Dim :: = if(Week_Liable>'$(vMax_Week_DIM)','$(vMax_Week_DIM)',Week_Liable)

where   

vMax_Week_DIM =:: =max({1}Week_Liable)

Dimension:  '$(V_Week_Dim)'

After using this variable I'm getting the below error.

Thanks...

[krish2459]

Any help.

Thanks..

[justISO]

Hi, I guess your 'Week_Liable' field is number and you comparing > it with string '2340'. How without quotation marks?:

V_Week_Dim :: = if(Week_Liable>$(vMax_Week_DIM),$(vMax_Week_DIM),Week_Liable)

[vinieme12 · Accepted solution]

As below  

V_Week_Dim 

If(Week_Liable>$(vMax_Week_DIM),$(vMax_Week_DIM),Week_Liable) <<Define without leading = sign and no single quotes 

In chart use 

=Aggr($(V_Week_Dim),Week_Liable)