1 Reply Latest reply on Dec 12, 2019 6:30 PM by swaroop.gantela

    Column Total adding up to more than the constituent Subtotals

    Thomas Warren

      Unfortunately i can't post the workbook but have included screen shots.

       

      I have one Measure HOURS... that i have sum'd into two columns.   Actuals_RAW which is literally all HOURS in the data set... RAW_DATA get it.   ACTUALs has some filtering done SUM( if A='xxx' then HOURS end)  Nothing complicated so far.

       

      Notice that they both column total to 3783..... which is what i want with Actuals_RAW.... but Actuals is missing the bottom 57 Hours.... YET it still COLUMN Totals to 3783.

       

      How can a column TOTAL add up more than what is in the constituent pieces???