Set Analysis with Variable

[#1]

Hi,

i have a variable as varFromDate where i put year = 2013

in below, it's not working with variable .

=Count({$ +<%Year={"<=[varFromDate]"}, TYPE={'T'} >} DISTINCT EmpCode)

if i use below it's working.

=Count({$ +<%Year={"<=2013"}, TYPE={'T'} >} DISTINCT EmpCode)

any idea why it's working with variable?

[Gysbert_Wassenaar · Accepted solution]

If varFromDate is indeed a variable and not a field name try it like this:

=Count({$ +<%Year={"<=$(varFromDate)"}, TYPE={'T'} >} DISTINCT EmpCode)

[#3]

thanks., it works