Skip to main content

How to Generate a Score from a Table on Dashpivot Web

Learn how to calculate and display a percentage score from a Default or Prefilled table using formulas

Adriana De Souza avatar
Written by Adriana De Souza
Updated over a week ago

Generating a percentage score at the bottom of a table allows you to automatically calculate results such as pass rates or assessment scores. In Dashpivot Web, if your data is stored in a Default table, you must use a separate Prefilled table to display the score. If your data is already in a Prefilled table, you can calculate and display the score within the same table. This ensures your score updates automatically as responses are entered.

Prerequisites

Before you begin make sure you have the following:

  • Plan: FreeTrial, Standard, Pro, Premium, Platinum

  • Permission: Org Controller (Home Folder) or Org Controller, Project Controller, Team Controller (Team Folder)

  • Skills Required: Dashpivot

  • Device Type: computer

  • Subscription: Dashpivot Web

Step-by-Step Instructions

  1. Open the form template in edit mode.

  2. If your data set to calculate the % score is in a Default table, use a separate Prefilled table as your summary display.

  3. If your data set is already in a Prefilled table, you can use the same table to display your score cell.

Example (Default table → Prefilled table):

  1. From the Default table, enter your formula for the score into the Prefilled table:

    =COUNTIF(Table1!B:B,"Pass")/COUNTA(Table1!B:B)*100

  2. Replace Table1! with the name of your Default table. Column B:B should contain the assessment results.

Example (Prefilled table only):

  1. In a Prefilled table, enter the score formula at the bottom of the table or where you need to display the score:

    =COUNTIF(B1:B4,"Pass")/COUNTA(B1:B4)*100

  2. Replace B1:B4 with the range of cells you need to calculate the score from.

  3. Press Enter to apply the formula.

  4. Preview the template to confirm the score calculates correctly.

  5. Save the template.

Note

  • Default tables do not support formula cells directly, so scores must be calculated in a Prefilled table when using Default tables.

  • The formula calculates the number of “Pass” results divided by the total number of entries, then multiplied by 100 to generate a percentage score.

  • To display the percentage symbol (%) in the result cell, add &"%" to the end of your formula. For example:

    • =COUNTIF(B1:B4,"Pass")/COUNTA(B1:B4)*100&"%"

    • =COUNTIF(Table1!B:B,"Pass")/COUNTA(Table1!B:B)*100&"%"

Related Articles
How to generate a Pass/Fail result at the bottom of a table based on a count on Dashpivot Web
How to generate an overall Pass/Fail based on score in a table on Dashpivot Web
How to Calculate a Percentage Complete in a Dashpivot Table
How to Calculate the Percentage of Rows Meeting Multiple Criteria in a Table (Dashpivot Web)
How to Calculate a % Score Based on List Dropdown Selections in a Row on Dashpivot Web
Did this answer your question?