PREVIOUS MONTH DATA

[sagaraperera]

Dear All

I using following formula to get a previous month data 

=MonthEnd(max(MARKETING_DATE),-1)

But this formula get a result only last month i want to get a sales value using above formula. may data field name is   GROSSTOT

please help

thanks

sagara

[Vegar]

Try this

Sum({<MARKETING_DATE = {">=$(=MonthStart(max(MARKETING_DATE),-1))<$(=MonthEnd(max(MARKETING_DATE),-1))"} >}GROSTOT)

[Brett_Bleess]

Sagara, did Vegar's post get things working as you wanted?  If so, do not forget to come back to the thread and use the Accept as Solution button on his post to give him credit and let others know it worked.  If you are still working upon things, leave an update for us.

Regards,
Brett