- 29 Feb 2024
- 1 Minute to read
- Print
- PDF
Calculated Pillar Percentage
- Updated on 29 Feb 2024
- 1 Minute to read
- Print
- PDF
Calculated Pillar Percentage
Please go through the source data Source Data Explained
Inside source data please find Calculated Pillar Score
below Scoring row.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
Inside source data please find Pillar Name, which will be merged of 2 or more template fields.
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_PercentageRepeat steps 2 to 5 for all pillars assigned to your team.
***{{pillar_name}}_Pillar_Percentage=PERCENTAGE(Pillar Total,_out_of)