Data manipulation on graph/grouping

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!

This topic was automatically closed after 70 days. New replies are no longer allowed.