Skip to Content
0
Former Member
Jan 19, 2009 at 04:52 PM

Exclude item from Total

24 Views

I am having trouble with a subtotal. I have a formula that adds two fields together to give me an invoice total. However there is an item that I would like to exclude from being calculated into my total.

I have no idea how i could tell the formula to not include the item. I was thinking an IF THEN formula would work.

if <> "0001" then +

but that didn't do anything. Is there a way to do this?

Thanks!