get current month vs previous month

[arulsettu]

hi

i am trying to show current month vs previous month in bar chart

what i did is

sum({<FiscalPeriod={$(=max(FiscalPeriod)),$(=max(FiscalPeriod)-1)}>}Customer)

it shows maximum month and previous month

how can i show current vs previous month any help?

[#2]

I have attached sample QVW . Hope this helps.

Regards,

Raksha

[arulsettu]

sorry using personal edition

can you post the code

thanks

[#4]

Hi

Your FisicalPeriod only include the Month part of the date.

Try to create another field using MonthStart

Then you can select current month instead of like September for every previous years.

Thank you

PC

[senpradip007]

Try like:

Sum({<FiscalPeriod={'$(=Max(FiscalPeriod)-1)), $(=Max(FiscalPeriod))'} >} Customer)

[arulsettu]

it shows nothing

[arulsettu]

can you show me how

[PrashantSangle]

Hi,

Write 2 expression:

1st for Current Month:

sum({<FiscalPeriod={"=$(=max(FiscalPeriod))"}>}Customer)

2nd for Previous Month:

sum({<FiscalPeriod={"=$(=max(FiscalPeriod)-1)"}>}Customer)

Regards

[senpradip007]

Try like:

Sum({<FiscalPeriod={$(=Max(FiscalPeriod)-1)), $(=Max(FiscalPeriod))} >} Customer)

[jyothish8807]

Hi Arul,

Your script looks good to me.

Max(month) and current (month)  will be same. if you dont have entries of current month then you wont be able to get current month.

Regards

KC

[arulsettu]

hi

its showing every month