How to calculate an average at the end of the last year ?

[#1]

Hi,

I want to calculate an average at the end of the last year. I want to put the condition in the following formula but I don't find the good way :

avg([Prix de vente]).

Can you help me to find the good formula please ?

Thanks.

Regards

[vgutkovsky]

Something like this should work:

avg({$<Year = {$(vLastYear)}>} [Prix de vente])

This comes from the Set Analysis article in the help file. In this example, you would set a variable vLastYear to year(today())-1

Regards,