Hi all and thank you in advance to who will help me on that issue.
I have a table payments with amount and currency and another table with exchange rates. Payments can be on many currencies.
I need a simple group by with a sum of EUR converted amount but I cannot manage how to accomplish it.
I have to show a simple total paid and unpaid pie graph.
I thought about storing the converted amount on DB, but it should change very frequently and it could be a big waste of WU
I need something like a view in SQL but I can’t find the way.
Thank you!