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.