I have multiple currency and its values in different list and Currency is lookup in the main list so user can select from dropdown and can enter its cost.
Main List field:
Currency- Lookup in main list. Currency list has currency field and exchange rate field which is number type field: user needs to select currency from dropdown options in main list
Cost - Number type: user need to enter values here
Based on the above inputs from user. I want to calculate Expected Cost
Expected Cost: exchange rate*Cost. Expected cost change when user change currency or cost.
Thanks in advance