Calculated Pillar Percentage
  • 29 Feb 2024
  • 1 Minute to read
  • PDF

Calculated Pillar Percentage

  • PDF

Article Summary

Calculated Pillar Percentage

  1. Please go through the source data Source Data Explained

  2. Inside source data please find Calculated Pillar Score
    below Scoring row.

  3. Find the dataset field name for Pillar Total to calculate the percentage using the Percentage function, and with the '_out_of' value present below the pillar name and in the Calculated Pillar Score row

  4. Inside source data please find Pillar Name, which will be merged of 2 or more template fields.

  5. Create a dataset field name : {{pillar_name}}_Pillar_Percentage
    For e.g Let say if pillar name is Racial justice statement then dataset field name will be Racial_justice_statement_Pillar_Percentage

  6. Repeat steps 2 to 5 for all pillars assigned to your team.

Syntax for creating the Pillar Percentage

***{{pillar_name}}_Pillar_Percentage=PERCENTAGE(Pillar Total,_out_of)


Was this article helpful?

What's Next