1 Reply Latest reply on Jan 18, 2013 7:22 AM by Catherine Rivier

    Grand Total Summation Issue?

    gall3on

      I created a formula with the following construct:

       

      ROUND(SUM([Sales] )*[Fulfillment Rate],0)

       

      where [Fulfillment Rate] is a parameter value of 65%.  I’m getting the result below:

       

      Day of Date

      Sales

      Fulfilled

      1

      0

      0

      2

      3

      2

      3

      2

      1

      4


      5

      1

      1

      6

      1

      1

      7

      2

      1

      8

      4

      3

      Grand Total

      13

      8

       

      My summary of starts should be 9, but I’m receiving the value of 8?  Is this with the formula itself or is the Grand Total Calculation doing its math differently by just applying a straight 65% against sum of my Sales?

        • 1. Re: Grand Total Summation Issue?
          Catherine Rivier

          Hi Abigail,

          Unfortunately I may not be able to fully answer because I don't know your data set.  But I would guess it has to do with your rounding here:

          ROUND(SUM([Sales] )*[Fulfillment Rate],0)

          For example, if you added 4.4 and 4.4, you'd get 8.8, which rounds to 9.  But if you rounded them before adding, you'd get 8.  Tableau's Grand Totals run on the overall value - so it will round the sum of all sales, rather than adding up the individual rounded values.  So the total you're seeing is likely correct, just the rounding is causing it to look funny.

          Instead of rounding in the equation, consider just using SUM([Sales]) as is and formatting the data to show 0 decimal places.

           

          Let me know if this doesn't do what you're looking for!