Sage 50 Report designer - IF THEN ELSE expression syntax
Posted: 05 Jan 2012, 20:11
I am trying to print a detail line where an entry in a particular column is printed or left blank not by whether it is (e.g.) Debit or Credit but by the evaluation of an expression.
Example:
One column in the detail line is for sales invoice values (SI) or sales credit values (SC).
In the variable specification for the invoices and credits column, I would like to put something like:
if AUDIT_SPLIT.TYPE= “SI” or AUDIT_SPLIT.TYPE = “SC” then AUDIT_SPLIT.GROSS_AMOUNT
but this is an invalid expression.
Assuming that what I am trying to do is possible, any advice on how pls?
Example:
One column in the detail line is for sales invoice values (SI) or sales credit values (SC).
In the variable specification for the invoices and credits column, I would like to put something like:
if AUDIT_SPLIT.TYPE= “SI” or AUDIT_SPLIT.TYPE = “SC” then AUDIT_SPLIT.GROSS_AMOUNT
but this is an invalid expression.
Assuming that what I am trying to do is possible, any advice on how pls?