Need expression for previous month

[#1]

Hi all,

  I need to show previous month amount  on selecting the current month PFA

[tresesco]

Your month field is empty. Correct the date format, and reload to get month properly, and re-upload sample qvw.

[#3]

Hi Tresesco

PFA

[PrashantSangle]

Hi,

I go through your data,

You have many date for similar month,

So you want sale for same month date of previous month ??

or complete sale of previous month?

Regards,

[#5]

Hi Max,

Here my date field is 'pstng date'. i need to show complete sale of previous month

[tresesco]

See the attached sample.

Expression:

Sum({<month= , [Pstng Date]={">=$(= MonthStart(Addmonths(Max([Pstng Date]),-1)))<=$(= MonthEnd(Addmonths(Max([Pstng Date]),-1)))"}>}Amount)

[lironbaram · Accepted solution]

hi see attach example

you have to text boxes

1. current selection amount

2 . previous month amount

[#8]

Hi Liron/tresesco,

  If you don't mine can you please explain the expression bco'z  i don't get the use of add months  over there

Thanks & Regards,

Nagaraj

[tresesco]

Addmonths(Max([Pstng Date]),-1) ---- this takes you -1 month ahead, i.e. one month backward from the maximum date of [Psttng Date] possible.

MonthStart(Addmonths(Max([Pstng Date]),-1)) ---- further works on that one month earlier date. MonthStart() gives the starting date of that date which is one month earlier, effectively, it gives you the first date of the earlier month.

[#10]

Thank'z for your response tresesco.., but wen i tried the expression by removing add months .. it's working fine