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.


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


Thank you