Static Variable

[nihhalmca]

Hi All,

I want to create static variable for max QuaterNum.

I created variable like vCurrentYrQtr = Max(QuaterNum).

However it is working on current selection.

For instance: vCurrentYrQtr is '20151 but if click year as 2014 and quarter as 4 by the time it shows vCurrentYrQtr is '20144'.

My requirement is if i click any year and quarter the variable should show only max QuaterNum like '20151'.

Regards,

Nihhal.

[Anonymous · Accepted solution]

Hi,

try with  vCurrentYrQtr =max({1}QuarterNum), where {1} excludes all selections.

BR,

Elena

[nihhalmca]

Thanks Elena