AnsweredAssumed Answered

Currency calculations

Question asked by coreequip on Sep 28, 2016
Latest reply on Sep 28, 2016 by philmodjunk

Good Morning,

 

i have the following table and would like to do an calculation for the Cost field. Mine somehow doesn't work:

 

If ( Currency = "CAD"; "" ; If ( Currency = "USD"; Supplier List Price * Products::ExchangeRate_USD; If ( Currency = "EUR"; Supplier List Price * Products::ExchangeRate_EUR; "" ) ) )

 

I would like to add a price to the "Supplier List Price" field, mostly it is Canadian Dollar, which i put as a standard in the dropdown menu.

But sometime we have USD or EUR, so i would like to have a calculation when the dropdown menu says CAD, i can modify the "cost" field by hand, but if it USD or EUR I put the USD Price into the "Supplier List Price" field and then the dropdown on USD and it automatically calculates the Cost.

 

I have the current exchange rates on the layout.

fm15.jpg

Hope I said it in the right way. Looking forward to hear your solutions.

 

Thank you

 

Rouven

Outcomes