Calculating the number of empty fields on a custom form

[KevinGi2]

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?

[Sven-iX · Accepted solution]

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)