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 )