2 Replies Latest reply on Oct 10, 2016 12:22 AM by Norbert Maijoor

    Formula required to count and % of members from quadrants.

    Siva raja

      Hi,

      I have 4 quadrants. Quadrant is a column created manually in query. This column will have q1, q2, q3, q4 inside. Example: q1 will have values corresponding to quadrant 1. I need to find the % of members.

      Logic for Quadrant 1 %:

      (q1 members/(q1 members+q2 members+q3 members+q4 members)) *100

       

      Now i need to find the count of members and percentage for respective quadrants. Please help me to write calculated field. Any help would be appreciated since its an urgent case.

       

      Thanks

      Siva