Help me with the error please

[#1]

  Sum({<Date >=$(vCurrentMonthstart) and Date <= $(vCurrentMonthend)>},[GL Post Amount])

I am getting error with the above expression.Please help me.

Thanks in advance

[MayilVahanan]

Hi

Try like this

Sum({<Date = {">=$(=Date(vCurrentMonthstart)) <= $(=Date(vCurrentMonthend))"}>} [GL Post Amount])

Note:

Please check the date format. Both must be in same format

For ex: MMDDYYYY means, both must be in MMDDYYYY format

[jagan]

Hi,

Try this expression

=Sum({<Date={'>=$(=vCurrentMonthstart) <= $(=vCurrentMonthend)'} >} [GL Post Amount])

Using this expression still you did not get the results then check the date format in variables and Date Dimension, the format should be same for the variables and Date dimension values.

Regards,

Jagan.