Calculating the number of empty fields on a custom form | Community
Skip to main content
K
KevinGi2
November 5, 2024
Solved

Calculating the number of empty fields on a custom form

  • November 5, 2024
  • 1 reply
  • 578 views

Hey all -- I am trying to figure out a way to get a percentage readout of the number of fields on a custom form that are empty. It should essentially be the number of empty fields divided by the total number of relevant fields. Not entirely sure how to accomplish that. Would I put together a formula for a calculated field?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Sven-iX

Hi @kevingi2 

 

This is a bit hokey but our tools in calculated fields are limited.

for every field, check whether it's blank and if so we print X
then we get the length of that string which is a number of how many fields were blank

then divide by the total number of fields. 

 

ROUND( LEN( IF(ISBLANK({DE:fieldA}),"X","")+ IF(ISBLANK({DE:fieldB}),"X","")+ IF(ISBLANK({DE:fieldC}),"X","")+ IF(ISBLANK({DE:fieldD}),"X","")+ IF(ISBLANK({DE:fieldE}),"X","")+ IF(ISBLANK({DE:fieldF}),"X","")+ IF(ISBLANK({DE:fieldG}),"X","")+ IF(ISBLANK({DE:fieldH}),"X","") )/8*100,0)

 

1 reply

Sven-iX
Community Advisor
Sven-iXCommunity AdvisorAccepted solution
Community Advisor
November 5, 2024

Hi @kevingi2 

 

This is a bit hokey but our tools in calculated fields are limited.

for every field, check whether it's blank and if so we print X
then we get the length of that string which is a number of how many fields were blank

then divide by the total number of fields. 

 

ROUND( LEN( IF(ISBLANK({DE:fieldA}),"X","")+ IF(ISBLANK({DE:fieldB}),"X","")+ IF(ISBLANK({DE:fieldC}),"X","")+ IF(ISBLANK({DE:fieldD}),"X","")+ IF(ISBLANK({DE:fieldE}),"X","")+ IF(ISBLANK({DE:fieldF}),"X","")+ IF(ISBLANK({DE:fieldG}),"X","")+ IF(ISBLANK({DE:fieldH}),"X","") )/8*100,0)

 

    Terms & ConditionsAccessibility statement

    Loading footer...