In most cases you have three options:
- represent 0 values in the same way you represent another values
- not represent 0 values if possible
- represent 0 values as symbol(s) when it means absence of value
Below are examples of all options.
Option 1:
# Product Qty Price Discount (%) Gross Net
----------------------------------------------------------------
1 Hammer 1 $2.30 $0.30 (13.04%) $2.30 $2.00
2 Crowbar 0 $9.95 $0.00 (0.00%) $0.00 $0.00
3 Nail 10 $0.15 $0.00 (0.00%) $1.50 $1.50
================================================================
Total $3.80 $3.50
Option 2:
# Product Qty Price Discount (%) Gross Net
----------------------------------------------------------------
1 Hammer 1 $2.30 $0.30 (13.04%) $2.30 $2.00
2 Crowbar $9.99
3 Nail 10 $0.15 $1.50 $1.50
================================================================
Total $3.80 $3.50
Option 3:
# Product Qty Price Discount (%) Gross Net
----------------------------------------------------------------
1 Hammer 1 $2.30 $0.30 (13.04%) $2.30 $2.00
2 Crowbar - $9.95 - - -
3 Nail 10 $0.15 - $1.50 $1.50
================================================================
Total $3.80 $3.50