set analysis year-1

[zied_ahmed1]

Hello,

I would like to display value of the year-1 for a year selected i use this but this gives me the value of the year selected :

=sum({$<Year= {$(=Year(Today())-1)}>} ACCOUNTINGCURRENCYAMOUNT)

Thanks

omarbensalem‌ stalwar1‌

[tresesco · Accepted solution]

Try like:

=sum({$<Year= {$(=Max(Year)-1)}>} ACCOUNTINGCURRENCYAMOUNT)

[Chanty4u]

check here max possible ways displayed

set analysis (max year and last year)

[OmarBenSalem]

Works fine for me !

How are you selecting ur Year? is it the same Year field u're using in this expression? Or u have another Year field (maybe calculated) ?

[zied_ahmed1]

I changed the name of the field Year in the master calendar but same thing i have the same values for year and year-1

[zied_ahmed1]

Same thing it doesn't work...

[OmarBenSalem]

Hold on a second :

in your expression, you're using one Year field; and then you're filtering by another Year field (the one from the master calendar) ?

Is that so?

[tresesco]

There could be many feasible reasons why it would not work. Try to share your sample qvw.

[zied_ahmed1]

Yes I changed the name of field Year in Master calendar to Annee and this is the filter :

And this is the set analysis  :