need expression for max(date) and previous month same date sales

[#1]

Hi,

Can anyone share me the max(date) sales and previous month same date sales.

when i select the date in list box,one column should show that date sales and one column should show previous month same date sales.

regards,

baru

[#2]

Hi, Please use the set expresiion for the previous month same day sales:

Sum({DATE_FIELD={$(=(DATE_FIELD-30))}}Sales)

If you have any problems, please provide the qvw with some data.

[jagan · Accepted solution]

Hi,

Try this expressions

For Current month

    =Sum({<DateFieldName={"=$(=Max(DateFieldName))"}>} Sales)

For Previous month:

     =Sum({<DateFieldName={"$(=Addmonths(Max(DateFieldName), -1))"}>}Sales)

Hope this helps you.

Regards,

Jagan.