AnsweredAssumed Answered

Currency question

Question asked by henryhu91 on Feb 21, 2013
Latest reply on Mar 15, 2013 by philmodjunk

Title

Currency question

Post

      

     Hello FM users, I've a question over currency. 

     I've Currency field from related table to store the currency rate.

     Users will manually change for updated currency rate.

     I’m going to have two fields for US price and China price

     I believe creating calculation field on US price and China price fields will work to multiply and divide with currency rate field from related table. 

     If users choose to input in US price field for an item, it will automatically convert price for China Price field.

     If Chinese currency (Yuan) goes up, it will be updating in China Price.

     If users choose to input in China Price, it will automatically convert the price for US Price. 

     Even though Chinese currency (Yuan) goes up, it will not change because we purchase the item when currency is not up.

     I will be really appreciate any of your advice or help. 

Outcomes