- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Variable not working
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...
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)
If a post helps to resolve your issue, please accept it as a Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Any help.
Thanks..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)
If a post helps to resolve your issue, please accept it as a Solution.