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!

Solved Solved
0 2 266
1 ACCEPTED SOLUTION

Steve
Participant V

Something like this?

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

View solution in original post

2 REPLIES 2

Steve
Participant V

Something like this?

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

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%.”

Top Labels in this Space