Previous year for selected year from filter

[sayali_gajare]

if(GetSelectedCount(InvYear)=1,

Sum({$<Year={'$(=max(InvYear)-1)'}>} [#GrossAmount]*ConvertRate),

Sum([#GrossAmount]*ConvertRate)

)

currently I have data for year 2018,19,20,21

when I select any year from filter I didnt get previous year data it shows data for selected year only

[Taoufiq_Zarra]

@sayali_gajare  Maye be :

if(GetSelectedCount(InvYear)=1,

Sum({$<Year={'$(=getfieldselections(InvYear)-1)'}>} [#GrossAmount]*ConvertRate),

Sum([#GrossAmount]*ConvertRate)

)

[sayali_gajare]

Thanks but not working

[AshutoshBhumkar]

Hi,

Can you please post an image of how your expression editor looks like and what is being calculated in set expressions?

Maybe, that will help us to understand more. The same kind of expression is working for me.

e.g 

If(GetSelectedCount (Year)=1,
Sum({<Year = {"$(=Max(Year)-1)"}>}Sales),
Sum(Sales)
)

Thanks,

Ashutosh