Exhange Rate Average

Hi All,

I need some help with the following topic:

I want to define a yearly average exchange rate column and I am using the next formula for this:

public GLDetail' [Year] is the year column and ExRateUSD2 contains the necessary exchange rate.

The result after the running will be the average exchange rate per day not the average exchange rate per year.

Could you help me please how can I solve this situation?

Many thanks in advance! 🙂

E.