1 Reply Latest reply on Jun 21, 2012 9:20 AM by juan.perez

    Calculating Divisin within a single pane

      Hi

       

      What im trying to do is to divide the values from the 3rd column by the values from the 6th column like this:

       

      columns.PNG

      where in the first row i would get 1 or 100%

       

      in the second row i would get 0.037 or 3%

       

      any idea on how to do this? Thanks in advance

        • 1. Re: Calculating Divisin within a single pane

          I have already solved this in 2 different ways, the first one:

          what i was actually trying to do is to get the percentage of the third column regarding the last column, the fast and clean way was creating a table calculation like the following

          Porce1.PNG

           

          the second way  involved using the following formula in a calculated field

          Porce2.PNG

          Where SumaTotalis another Calculated field  with this formula:

          TOTAL(COUNT([Total]))