5 Replies Latest reply on Nov 9, 2016 8:16 AM by Norbert Maijoor

    How to convert a column to a percentage and use the percentage in a calculated field?

    Jagdeep Bhogal

      Hi all,

       

      I have created a table that includes the count of sales by district, with the sum of the population in each district.

       

       

      In a new sheet, I have converted all of the values to percentages (%) by right-clicking, Quick Table Calculation and then Percent of total for both of the measures/columns.

       

       

      Does anyone know how I can create a calculated field that allows me to divide the central column (% of total count...) by the column on the right (% of total population...)? I need to divide the PERCENTAGE NUMBERS and not the count numbers.

       

      Thanks

       

      Jag