Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using Set Analysis (QV11) with Alternate States and am trying to get a prior year calculation. The expression below works for the selected year, and is summing for the selections in the alternate state (GroupOne) but applying the time dimension selections in the default state. I can't seem to modify this to get a prior year calculation. The Year is a character string.
sum({GroupOne<Year = $::Year, Month = $::Month>} PremiumByPolicy) * .001
Thanks in advance...
Perhaps like this:
sum({GroupOne<Year = {'$(=max({$}Year)-1)'}, Month = $::Month>} PremiumByPolicy) * .001
If not, please post an example document with sample data.
Thank you!
That worked perfectly.
Brent