Exhange Rate Average

[Anonymous]

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.

[Anonymous]

Hi Daxer,

Thank you for your comment!

I would like to use just one average exchange rate for every single year but the formula generates more rates.

Erik

Erik

[Anonymous · Accepted solution]

If you want an average per day, you have to average over days, not years.