 # How to count populated fields in forms

I need an expression that results in the sum of all the populated fields of a form, as if each of the fields added +1.
For example, if I have a form with 7 fields, and only 5 are populated, the result of the expression is number “5”.
It would also be interesting how I can express this formula in percentages.

Thanks! Something like this?

``````(
0
+ IFS(ISNOTBLANK([column1]), 1),
+ IFS(ISNOTBLANK([column2]), 1),
...
+ IFS(ISNOTBLANK([columnN]), 1)
)``````
1 Like

Gracias Steve! Eso funcionó!

I share how is the formula to calculate the percentage.

``````(
(
0
+ IFS (ISNOTBLANK ([name]), 0.1),
+ IFS (ISNOTBLANK ([type]), 0.1),
+ IFS (ISNOTBLANK ([description]), 0.1),
+ IFS (ISNOTBLANK ([identifier]), 0.1),
+ IFS (ISNOTBLANK ([unit_measure]), 0.1),
+ IFS (ISNOTBLANK ([special_type]), 0.1),
+ IFS (ISNOTBLANK ([special_type_detail]), 0.1)
)
* 1)
/ 0.7
``````

QUOTE: “Percent is a Decimal with special display characteristics. For example, a Percent value of 0.0 is displayed as 0%; 0.05 is displayed as 5%; 0.2 as 20%; and 1.0 as 100%.”

2 Likes