current month vs last year same month

[arulsettu]

hi

i am showing current month vs last year same month

this code showing current month vs last month

sum({<FiscalPeriod={$(=max(Num(Month(Date(Today()))))),$(=max(Num(Month(Date(Today())))-1))}>}Customer)

i want to make sure the above code is correct and how to get last year same month

thanks

[arulsettu]

any help?

[geert_gelade]

For this kind of comparisons, I always calculate a "MonthID" in the script:

(num(Year(Date))-1)*12 + Month(Date) as MonthID

In your expressions you can use afterwards:

Sum({$<MonthID = {$(=Max(MonthID)-12)} >} Amount) for month in previous year

Sum({$<MonthID = {$(=Max(MonthID))} >} Amount) for month in current year

Hope this helps

[rubenmarin]

That expression executed today will show the sum of the 'Customer' field for Fiscal Period '9' and '8'

Can you upload a sample?

[arulsettu]

here it is

[rubenmarin]

Following your expression for month vs month, year vs year should be:

sum({<FiscalYear={$(=max(Num(Year(Date(Today())))-1)), $(=max(Num(Year(Date(Today())))))}, FiscalPeriod={$(=max(Num(Month(Date(Today())))))}>}Customer)

[arulsettu]

if i want to display current month and last year month in two charts how to split the code?

thanks

[arulsettu]

it showing current month only

[rubenmarin]

I'm not sure to understand the requirements.

I made some graphs in attached doc. Hope one of those is what you're searching