Expressions with {1}

[#1]

Hi,

From the set analysis document, if we have an expression like

SUM({1}net)

it will ignore all selections except for the dimensions.

I have the following expression for a table with dimension ='Dimension'

SUM({1} {1<Year={'$vMaxYear'}, Date={'<=$vMaxDate'}>}net)

but my table doesn't disregard other selections and value changes if I select any other parameter.

Could someone please tell me what I am doing wrong here?

thanks,

Manoj

[Gysbert_Wassenaar]

Try this: SUM({1<Year={'$(vMaxYear)'}, Date={'<=$(vMaxDate)'}>}net).

[#3]

try like this

SUM({1<Year={'$vMaxYear'}, Date={'<=$vMaxDate'}>}net)

[#4]

if require put   end }

[#5]

I think I know what is happening. My variables (year and dates) are changing with selections causing the values to change. No difference by removing {1} though.

thanks,