1 Reply Latest reply on Jun 27, 2017 2:05 PM by Patrick A Van Der Hyde

    Joins and if then formulas

    Alex Martino

      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

      ([Co Id])

      END