AndreaF
2 years agoContributor III
Convert Application table data using FxRates
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
Solved by using the BRApi.Finance.Data.GetCalculatedFxRate() function