Forum Discussion

AndreaF's avatar
AndreaF
Contributor III
2 years ago

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

  • AndreaF's avatar
    AndreaF
    Contributor III

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