3 Replies Latest reply on Mar 21, 2016 9:23 AM by Corey Thompson

    Division of two numbers coming out completely wrong.

    Corey Thompson

      Hi everyone,

      I'm pretty new to Tableau, so I'm getting stuck often, but this one I can't seem to nut out.

       

      Screen Shot 2016-03-21 at 16.04.41.png

       

      I'm trying to divide Performance with Organic Value for each site. Organic Value is the for everyone. Both performance and Organic Value are aggregate values.

       

      For the last column, I did a shelf calculation of [Performance]/[Organic Value]. The results should be

      0.043

      0.522

      0.016

      0.124

      0.002

       

      In the end, I do want to see what performance is of organic value as a percentage. So if there is an easier way to do that, please let me know.

       

      Cheers,

      Corey