Subtotals on pivot table where some values are NULL

[#1]

I have a sales table that pulls data from our contact management system, and our billing system.

Often, because of the deal the sales person put together, the customer won't be billed or invoiced immediately.

This means the sale amount is recorded in the contact system but the bill record from billing is NULL.

We are trying to make sure we accurately bill our customers, so my table compares the billing record to

the contact management's sale amount. Unfortunately, when I put the billing record in my pivot table, the subtotals come

out incorrectly.

I tried if(IsNull(Amount),0,num(Amount)), which looked better than all the NULL's, but still some of the subtotals come out

incorrectly.

What's really puzzling is some of the subtotals come out correctly, while others are wrong.

Any thoughts on what this might be?

[RedSky001]

Can you provide some sample data, there's not much to go on here without it.

Mark