9 Replies Latest reply: Aug 11, 2015 5:04 AM by chitra devarakonda RSS

    Sub Totals not equalling

    Andrew Thomas


      Hi

       

      I've added an expression in my table that returns a zero based on the condition and it seems to be working ok but for some reason the column total is still including the value of the records that return zero

       

        So I'm returning zero when ActualCostsLC - SalesActualCostslC = 0 otherwise I'm bringing in the sum of PlannedCostsLCV0.

      =

      if(sum(ActualCostsLC)- sum(SalesActualCostsLC) = 0 , 0, sum(PlannedCostsLCV0))

       

      The report returns zero for the condition but when I add a subtotal I still get the values in the total that have been excluded