I have a claim table connected to work order table (there can be multiple work orders per invoices) connected to invoices table (there can be multiple invoices per work order).
When I look at a crosstab I count about 30 claims with cost of 0 or negative value.
HOWEVER, when I do this formula below (and I do a countd on it) then I get a number that is much larger. Is this counting nulls (there are a lot of nulls)? Or might it have to do with the fact that each claim has multiple work orders and invoices and it's 500x counting haha. I could see a double/triple, but it's waaaaaaay more than that.
If [Total Adjusted Gross Amount] < 0 THEN
It would help to look at the workbook associated with this but my first thought here is to ask if the [Co Id] value is a Dimension and if it is included in the crosstab view you mention. Are there many Co Id values per claim? A view of the workbook would help to clarify what is going on.