do not include cancelled billings in getting new billings
display bill amount zero if bill is cancelled