Convert Application table data using FxRates

[AndreaF]

Hi, I have an Application table containing a number of attribute columns, a currency column (EUR,USD,TRY...) and an Amount column. The client wants a twin table that has all rows from the table 1, but with all values converted to euros.

I already have a dashboard that shows table 1 with a button to refresh its content (pulling data from other Application tables).

What is the best way of refresh table 2? I was thinking of creating an extensible rule to update table 2 on demand, but I have noticed I cannot use the api.fxrates in there...

Thank you

[AndreaF · Accepted solution]

Solved by using the BRApi.Finance.Data.GetCalculatedFxRate() function