Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
CNH_1978
Contributor II
Contributor II

Defining set analysis in a variable and using the variable within the expression

Hi, 

I am defining some set analysis in a variable like below..

vSetAnalysis

MonthYear={' & chr(39) & '$(vSelectedMonthYear)' & chr(39) &'}

I now need to use this variable in the set analysis in the actual expression like below but i can't get it to work..

Sum({<'$(vSetAnalysis)'>}Sales)

Can anyone help to get this to work please?

2 Replies
CNH_1978
Contributor II
Contributor II
Author

Does anyone have any ideas?

NitinK7
Specialist
Specialist

Hi

set variable like

vSet=monthyear

vr.JPG

 

then write below set analysis expression in textbox

=Sum({<Monthyear={"=$(vSet)"}>}sales)

or 

You can use below expression

=sum({<vSet>}sales)