10 Replies Latest reply on Oct 22, 2018 5:52 AM by Jeo Thomas

    Percentage of total suppliers

    Jeo Thomas

      I want to display the percentage of total supplies when applied a filter

       

      For that, I have created two calculated fields

       

      Calculated field 1. Count of suppliers - "COUNTD([Supplier Name])"

      Calculated field 2. Total suppliers fixed - "{COUNTD([Supplier Name])}"

       

      Using these calculated fields I tried to calculate the % of suppliers

       

      Calculated field 3. % of Total Suppliers - "[Count of Suppliers]/{[Total suppliers Fixed]}"

       

      But it is giving an error, below is the screenshot of the error.

       

      Please help!

       

      regards

      Jeo Thomas