Hi - can anyone tell me how you create an invoice template that calculates across the qty by cost per item and total in a way that doesn't display zeros in all the total columns in a template where you dont actually have any values yet. At thje moment we jsut do the top line but then each time you create a new invoice from the template you have to drag the formula fill vertically to apply to each line item in the invoice. I am sure there must be a way to hide the zeros in a template until you actually add some values to the invoice.
Thanks
Bookmarks