Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i m using Below expression:
=Sum({$<Date = {"<=$(=MonthEnd(AddMonths(Max(Date),-1)))"}>}Amount)
It is Working fine .when i select on Date field it is fine .
Date field contains 21/1/2013 format
If i use Month(Date) and i select on particular month it is giving output as 0.
Pls suggest me.
Thanks in Advance
Regards,
Divya
=Sum({$<M=,Month={"<=$(=MonthEnd(AddMonths(Max(Month),-1)))"}>}Amount)
this might help
What is the result of expr - MonthEnd(AddMonths(Max(Date),-1)) ? Is this result in date format?
Can you add sample qvw
Hi,
PFA,
Thanks in Advance
=Sum({$<M=,Month={"<=$(=MonthEnd(AddMonths(Max(Month),-1)))"}>}Amount)