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!



      Jeo Thomas