Foreign Currency Gains calculation

Greetings, -

Attached is the subject calculation. The 1st purchase is on 19-Aug-18 in EUR. It converts the $ amount to the equivalent EUR as on 17-Aug-18 (This EUR amount is incidentally higher than the actual EUR spend). The EUR so arrived at is then converted on the report date to calcute the fx gains.

I would have thought the original EUR spend on 19-Aug-18 would have been used to identify fx gains. What am I missing?

Many thanks

It’s a very theoretical, what-if style value. I wouldn’t pay it too much attention.

Thanks for your reply.

Noted. If its just theoretical and in my case very different from the actual fx gain, it would have been nice to have an option to hide the column.