How can I enter an if statement to leave the SalesInvoiceLines/@DiscountAmount field blank if the Discount value is equal to zero, but show if the value is anything greater or less than zero
Hello @Damilare_Odusanya,
Inside a field tagging element, you can have an expression like:
iif (SalesInvoiceLines/@DiscountAmount = 0, ‘’, SalesInvoiceLines/@DiscountAmount)
Or, you can have the field tagging element displaying this value inside an if tagging element that is bound to:
SalesInvoiceLines/@DiscountAmount != 0
Hope this helps!
Thank you Dailila, that fixed it