### Title

Calculation for text fields

### Post

Hello. I've been trying to find any similar posts in hopes in finding an answer, but can't seem to find what I'm trying to do, which is probably easy. I've tried using the "If (IsEmpty...)" function for this, since I have 5 possible fields that could be filled out with any sort of text, and need a field that will calculate if any one of these fields are filled out. I've done this with numbers, but not with any text. This is what I've tried to use for a calculation, which doesn't work or I'm missing something:

If (IsEmpty ( Department_Kiosk1); 0 ; 1 + (IsEmpty ( Department_Kiosk2); 0 ; 1) and so on.

Note: Have the calculation result a a number; Number of repetitions: 1; Have it checked to not evaluate if all reference fields are empty.

Trying to come up with, if any these fields are empty, it's counted as zero and if it is filled out, it counts it as one. Image attached is showing the 5 fields that could possible be filled out , along with the field that I'm trying to get this calculation to work for. Any help is greatly appreciated.

Your 5 fields appear to be something better set up as 5 records in a related table instead of separate fields.

Am I correct that you want the number of fields that are not empty?

If so....

Count ( Field1 ; field2 ; field3 ; field4 ; field5 )

should return the value that you seek.