Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
If varFromDate is indeed a variable and not a field name try it like this:
=Count({$ +<%Year={"<=$(varFromDate)"}, TYPE={'T'} >} DISTINCT EmpCode)
If varFromDate is indeed a variable and not a field name try it like this:
=Count({$ +<%Year={"<=$(varFromDate)"}, TYPE={'T'} >} DISTINCT EmpCode)
thanks., it works