Previous Month not working

[Anonymous]

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.

[Anonymous · Accepted solution]

Its worked now.

Just bypassed Year and Month in the expression.