2 Replies Latest reply on Jan 28, 2019 8:34 AM by Deepak Rai

    Calculated Field is not Summing correctly

    Brian Beck

      My calculated field is SUM(Denominator) * SUM(GoalPercent) which finds the Numerator Goal for each Sub-Dimension. When broken out for each Sub-Dimension, it is calculating correctly.

       

      However, when I try to report at the Parent Dimension level, the result is about 10 times too high (there are about 10 Sub-Dimensions). It appears to be summing the total of the Sub-Dimensions and then summing the sums together (much like if you were missing a join in SQL).

       

      I am new to Tableau, what am I doing wrong and how to I fix it?