3 Replies Latest reply: Jan 22, 2013 11:33 AM by Christian Conejero RSS

    Sum in Straight Table Double Counting Some Rows

    Kevin McGovern

      So I'm trying to do a sum of a dollar amount in a straight table but some rows are being counted twice.  If you look at the attached example, the row where the PARHrs are 1.3898 shows an amount of $112.20 in the table box but when I do Sum(PARAmt) in the straight table, a value of $224.40 is displayed.  This issue appears in a couple different places.  When I do a Sum(Distinct PARAmt) the true amount is displayed but I'm worried about this showing a smaller amount than expected under different scenarios.  Any insight into why the straight table would be doubling some of the values here would be greatly appreciated!  Thank you!