Pillar Total

Pillar Total

1. Please go through the source data Source Data Explained
2. Inside source data please find Pillar Total below Scoring row.
3. Inside source data please find Pillar Name, which will be merged of 2 or more template fields.
4. Find the out all the templatefields that goes into that pillar and add them e.g VALUE(RESPONSE(..)) + VALUE(RESPONSE(..))
5. Create a dataset field name : {{pillar_name}}_Pillar_Total
   For e.g Let say if pillar name is Racial justice statement then dataset field name will be Racial_justice_statement_Pillar_Total
6. Repeat steps from 2-5 for all the pillars assigned to your team.