DIfferent exchange rate applied to the amount

[SH_94]

Hi Community,

I would like to translate those amount value to certain currency as shown in the screenshot below. I plan to use formula tools to apply these exchange rate and presented value without applying the text input tool (to import the exchange rate and presented value).

May i know if anyone know how to build the workflow to cater the need of situation below.

[SH_94]

Hi @AngelosPachis ,

Thanks a lot again for your sharing. I just learn a new things today about the formula expression.

It is clear now.

Thank you so much for your time