# How to count single record's completion rate

Topic Labels: Data Formulas
Solved
721 3
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

Hey I would like to know if there is a way to create a  summary per record instead of per filed? like, how may empty per record? Many thanks!!

1 Solution

Accepted Solutions
11 - Venus

Okay, so from what you're describing, I'm imagining something like this:

Here's the formula I used:

``````IF(
OR(
{Field 1}, {Field 2}, {Field 3}, {Field 4}, {Field 5}
),
SUM({Field 1}, {Field 2}, {Field 3}, {Field 4}, {Field 5}) / 5,
0
)``````

Naturally, if you decide to add additional fields later on, you'll need to update the divisor in the equation.
Additionally, the 0 in the falsy parameter for the IF() function is optional.

If you want the formula to return nothing if the fields are all blank, then you can omit the 0.
If you always want a value to be returned, in this case a 0%, then you can just leave it in.

Be sure to confirm that your formula formatting is correctly configured.

3 Replies 3
11 - Venus

Hey @yuannc12

Without having many details about exactly what you're trying to do, it would seem that you first need to create a formula field that will return a summarized value for each record.
Then you would be able to use the values of that formula field to return the view-summarized metric that you're looking for.

5 - Automation Enthusiast

An example of my questions is, if I have a record (field 1(filled), field 2(empty), field 3 (filled), field 4(filled), field 5(filled)), how to create field 6 to calculate the percent filled of this singe record (filed 1-5) which is 80%? 🙂
with the formula, I'm not sure how to best compose the code, which I am looking for help as well

11 - Venus

Okay, so from what you're describing, I'm imagining something like this:

Here's the formula I used:

``````IF(
OR(
{Field 1}, {Field 2}, {Field 3}, {Field 4}, {Field 5}
),
SUM({Field 1}, {Field 2}, {Field 3}, {Field 4}, {Field 5}) / 5,
0
)``````

Naturally, if you decide to add additional fields later on, you'll need to update the divisor in the equation.
Additionally, the 0 in the falsy parameter for the IF() function is optional.

If you want the formula to return nothing if the fields are all blank, then you can omit the 0.
If you always want a value to be returned, in this case a 0%, then you can just leave it in.

Be sure to confirm that your formula formatting is correctly configured.