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


      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.