If Blank Then
Posted: 15 Mar 2024, 13:43
Hi Folks,
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:
But I cannot get it to work. I've even tried the "IF" function and whatnot but Sage Report Designer doesn't like it.
It's muddling my head now so can anyone help me and tell me what I'm doing wrong!
Cheers,
Tant
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