2 Replies Latest reply: Dec 31, 2013 9:32 AM by Omar Nouri RSS

    Set Analysis with Variable

    Omar Nouri

      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?