I've been searching the internet for hours to try and sort this with no luck!
In the details field on customer statements, I want it to show the customer's order number. I've managed to get it doing that but not all of our customers give us an order number and I don't really just want to leave the details blank on the statement.
So, I've been attempting to write an expression with essentially says "If AUDIT_SPLIT.DETAILS is blank then SPLIT.STMT_TEXT"
This is what I came up with:
Code: Select all
AUDIT_SPLIT.DETAILS = "" ? SPLIT.STMT_TEXT
It's muddling my head now so can anyone help me and tell me what I'm doing wrong!
Cheers,
Tant