Subtable

Hi There, I need some advise.

I got a subtable and it contain ‘Currency’, ‘Amount’ & ‘Actual Amount’. The Actual Amount is calculated based on what currency is selected.

The Actual Amount is default base on SGD

Example: Currency = HKD, Amount = 1,000

I want the actual amount = 172.00

May I know how to write the formula?

Regards
Raymond

Hi,

I would suggest adding an exchange rate field to your subtable, and your formula on the “Actual Amount” field should be Amount * value on the exchange rate field.
You can also make your exchange rate fields dynamic by referencing currency fields. This allows you to select the currency to convert and then get the respective exchange rate. For more details, please refer to this document.

Hi Fabio,

Thanks for sharing this info and exactly what I need. much appreciated.

Regards
Raymond

1 Like