11-23-2023 10:02 AM - edited 11-23-2023 10:03 AM
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! Go to Solution.
11-23-2023 12:37 PM
Solved by using the BRApi.Finance.Data.GetCalculatedFxRate() function
11-23-2023 12:37 PM
Solved by using the BRApi.Finance.Data.GetCalculatedFxRate() function