AnsweredAssumed Answered

Case Function

Question asked by gavjuan on Apr 28, 2015
Latest reply on May 6, 2015 by gavjuan


Case Function


I have an invoice layout that needs to be sent in different currencies depending on the account the money is being paid into. I want to select the relevant bank details according to the currency displayed prefixing the invoice total. I have a field with a dropdown list of currency symbols "£", "$", "€" etc. The Bank Details field has the Calculation below. It works except I want it default to Details Sterling for anyone without an alternative currency account.

Case  (Currency = "$"; Photographers Details::Details Dollar ; Currency = "€"; Photographers Details::Details Euros ; Currency = "£"; Photographers Details::Details Sterling ; Photographers Details::Details Sterling )