Skip to main content
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!

This topic has been closed for replies.

1 reply

try67
Community Expert
Community Expert
May 19, 2020

You would need to use a script that does it. I posted similar code many times in the past. Try searching the forums for "calcAverage".

Participant
May 19, 2020

Will do, thanks for the tip.