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

    Calculating Divisin within a single pane



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



      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



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


          Where SumaTotalis another Calculated field  with this formula: