I have an invoice database I’ve been running for years. I have a procedure that imports data from an order form database into the invoice database. I use zeroblank() extensively so empty fields simply display as blank but this no longer seems to work.
The line of code for each line item total is:
A1=zeroblank(Y1 * P1) of course the field names change accordingly so I have
A2=zeroblank(Y2 * P2), and so on for about 20 items.
The problem is blank numeric fields display with zeros instead of blank when imported.
edit: for some reason the asterisk doesn’t appear in the formulas above so I am substituting with an X