Generate an overall Pass or Fail result based on a total score calculated within a table. It is useful when responses are assigned numerical values and the final outcome depends on whether the total score meets a defined threshold. This applies to both Default and Prefilled tables in Dashpivot Web templates and is designed for template editors configuring score-based formulas.
Prerequisites
Before you begin make sure you have the following:
Plan: Standard (or higher)
Permission: Org Controller (Home Folder) or Org Controller, Project Controller, Team Controller (Team Folder)
Skills Required: Dashpivot, Basic excel formula skills
Device Type: computer
Subscription: Dashpivot Web
Step-by-Step Instructions
Open the template in Dashpivot Web.
Navigate to the table where scoring is configured.
Ensure each row contributes a numerical score (for example, through a scoring column or formula).
Decide where the overall Pass or Fail result will be displayed (either in the table footer or in a separate table cell).
Enter a formula to calculate the total score using the SUM function.
Default Table – Overall Pass/Fail Based on Score
If you are using a Default table (where rows can be added dynamically):
In a separate table or result cell, reference the scoring column using a table reference.
Use a SUM formula to total the scoring column. For example:
=SUM(Table1!B:B)
Wrap the SUM formula inside an IF statement to return Pass or Fail based on your required threshold. For example:
=IF(SUM(Table1!B:B)>=20, "Pass", "Fail")
Adjust the score column reference and minimum threshold value to match your requirements.
Prefilled Table – Overall Pass/Fail Based on Score
If you are using a Prefilled table (where the questions and number of rows are fixed):
In the bottom row of the scoring column (or another suitable result cell), calculate the total score. For example:
=SUM(B1:B5)
Use an IF formula to return Pass or Fail based on your required threshold. For example:
=IF(SUM(B1:B5)>=20, "Pass", "Fail")
Adjust the score range and threshold value to match your scoring requirements.
Save the template.