Participant
May 19, 2020
Question
Removing Empty Fields from Calculation
- May 19, 2020
- 1 reply
- 504 views
Hello,
I am trying to create a calculated field using a script that calculates the average of several fillable lines. The issue I'm running into is that some of these fields may not be filled out. One instance could have all 10 values filled in, but another instance could have just 7/10 fields. The calculation is counting the empty fields as zeroes rather than excluding them from the calculation. Any ideas?
Thanks!