CASE WHEN {currency} is CAD THEN {customer.balance} ELSE {{customer.balance}}/{exchangerate} END can this sort of a statement be used??

Never tried but

CAD

should likely be in

''

or `""`; you also might want to NVL on

exchangerate

, the double bracket on `customer.balance`feels like a typo as well

@Sandii thanks - yeah the typo was fixed and tried to add "" '' and brackets but still keep getting invalid expression. curious on how to use NVL here

Maybe something more like this:

CASE

WHEN {currency} = 'CAD'

THEN {customer.balance}

ELSE {customer.balance}/NULLIF({exchangerate}, 0)

END

@George McMullen thank you sir. that worked beautifully