Filling percentage

[Mark]

Hi, I wanted to ask if it is possible to somehow calculate how many fields are filled in on every record?

[eymen-elkum]

Hi Mark,

this is possible using the formula, just add a new field from float type and calculate it.

$filledPrecentage = 0;


ifThen(fieldName1, $filledPrecentage = $filledPrecentage + 30 );
ifThen(fieldName2, $filledPrecentage = $filledPrecentage + 30 );
ifThen(fieldName3, $filledPrecentage = $filledPrecentage + 40 );

filledPrecentage = $filledPrecentage;

[Nishan Perera]

@eymen Good stuff.