Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this
sum( {$<TRAN_YEAR= {"$(=Max([TRAN_YEAR]-1))"},DESCRIPTION= {'NRP'} >} [Actual])
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
maybe try this
use your date field
sum( {$<DATE_FIELD= {"$(=AddMonths(Max(DATE_FIELD),-13))"},DESCRIPTION= {'NRP'} >} [Actual])