sales tax calculation

[crow]

I have a portal with line items. On each item I have a yes/no tax drop down. I want to add up the items that have Tax=Yes and put them in toTaxTotal. I have:

If ( lineItems 2::taxYesNo = "Yes" ; Sum ( lineItems 2::sellExtended ) )

I end up with all the line items being totaled. Not just the ones that equal yes. How can I get it just to total the ones that equal Yes.

Thanks in advance.

[bcooney]

Like this...

SalesTax.zip

[crow]

Wow Thank You