Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Its worked now.
Just bypassed Year and Month in the expression.