Previous Month not working

Anonymous — Fri, 16 Oct 2015 05:44:33 GMT

Dear All,

I have created Period Number at script level in following way:

Fiscal_Year*12+num(Period_Number) as Period_Number,

And I have defined Current/Previous Month Variable in this way:

max(Period_Number)/max(Period_Number)-1

At Expression level, I m using following and my Current Month Expression working fine for every month but not working for Previous Month.

=sum({<MainGL={'>=$(=4000)<$(=4100)'},Period_Number={'$(=VCurrentMonth)'}>} DEBITAMT-CRDTAMNT)

=sum({<MainGL={'>=$(=4000)<$(=4100)'},Period_Number={'$(=VPreviousMonth)'}>} DEBITAMT-CRDTAMNT)

Am I missing something??

Pls Suggest.

Re: Previous Month not working

Anonymous — Fri, 16 Oct 2015 05:48:44 GMT

Its worked now.

Just bypassed Year and Month in the expression.