LAST MONTH OF LAST YEAR

[sagaraperera]

Dear ALL

Hi , I have the following expression to obtain Last Year based on the selected Month:

sum( {$<TRAN_YEAR= {"$(=Only([TRAN_YEAR]-1))"},DESCRIPTION= {'NRP'} >} [Actual])

But, when the selected Month = January, it does not change the Month.

The correct result should be November of the past year

[arulsettu]

try this

sum( {$<TRAN_YEAR= {"$(=Max([TRAN_YEAR]-1))"},DESCRIPTION= {'NRP'} >} [Actual])

[sagaraperera]

Dear Mr.Arul

IT IS COME TO LAST YEAR SAME MONTH BUT I WANT TO LAST YEAR PREVIOUS MONTH VALUE

SELECT DEC 2016

I WANT

VALUE OF NOV 2015

SAGARA

[arulsettu]

maybe try this

use your date field

sum( {$<DATE_FIELD= {"$(=AddMonths(Max(DATE_FIELD),-13))"},DESCRIPTION= {'NRP'} >} [Actual])