month

[raadwiptec]

i need to have last month only and this month only  sales as 2 different columns in the same chart. I tried using add months concept..

any sugg

[Chanty4u]

May be this?

1. Current Month sales Expression:    =Sum({<MonthNum={'$(=Max(MonthNum))'}>}Sales) 
2.  
3. Previous Month sales Expression:   =Sum({<MonthNum={'$(=Max(MonthNum)-1)'}>}Sales)

[MayilVahanan]

HI

Try like this

Sum({<Date= {">=$(=Date(MonthStart(Today(),-1),'DD/MM/YYYY')) <= $(=Date(Floor(MonthEnd(Today())),'DD/MM/YYYY'))"}>}Sale)

[raadwiptec]

i tried this Sum({<[Month]={'$(=Max(Month)-1)'}>}Sales) .. but my output is 0

[MayilVahanan]

Try like this

=Sum({<[Month]={'$(=Month(AddMonths(Today(),-1)))'}>}Sales)

[raadwiptec]

hi mayhil,

it should not be based on today .. for ex: if iam selecting 02 it should show 01 and if i select month 03 it should show 02

[vishsaggi]

Can you share a sample app to work on?

[MayilVahanan]

Hi

Try like this

=Sum({<[Month]={'$(=Max(Month)-1)'}>}Sales)

Note thtat: =Max(Month)-1 wil return 11 (Number format), if your month is in number format, it will work.

Otherwise,

Try like this

=Sum({<[Month]={"$(=Month(Date#(Max(Month)-1,'MM')))"}>}Sales)

[sasikanth]

HI

Try this

Current Month :  Sum({< Month= {"$(=Month(AddMonths(Max(Date_Field),0)))"}>}Sales),

Previous Month: Sum({< Month= {"$(=Month(AddMonths(Max(Date_Field),-1)))"}>}Sales),

Careful with date formats