I have a report that lists equipment used on a job. I have a field for each piece of equipment so 10 fields for 10 possible pieces of equipment.
on the invoice I want only the fields that are populated to display. is there a way to filter this and subtotal for only the fields that are populated and if there are none to have a text box that says no equipment was used.