10 Replies Latest reply on Apr 11, 2016 8:02 AM by C Palo

    Trouble with Subtotals of a calculation with percentages

    C Palo

      Hit a wall on this one...

       

      SAF $ = Total Ship $ * SAF% which varies by Vendor. Can't seem to get an accurate Grand Total.

       

      When I use SUM([SAF %])*SUM([Total Ship $])  the total is much bigger than expected as it's summing up the % and then multiplying by the Total Ship $

       

      How can I get the following to return $225,944 instead of $1.8M?

       

       

      Help please! Thanks!

       

      Cristina

       

       

      Desired output

         

      VENDOR #Total Ship $SAF %SAF $
      14931$2,355,9942.0%$47,120
      15176$151,6392.0%$3,033
      16565$535,89010.0%$53,589
      16715$350,5236.0%$21,031
      19430$714,30310.5%$75,002
      30043$249,03910.0%$24,904
      31031$63,2672.0%$1,265
      Grand Total$4,420,655$1,878,778
      $225,944
      5.1%