AnsweredAssumed Answered

Calculating Percentage of Empty Cells in a Found Set

Question asked by BrianWallden on Sep 4, 2014
Latest reply on Sep 4, 2014 by philmodjunk


Calculating Percentage of Empty Cells in a Found Set


I'm going to try to explain this as best as possible.  I have an interface that finds monthly data (machine settings) for a specific machine number and month.  I would like to analyze this returned data on a separate layout.  I would like to determine the completion percentage (i.e. so was the machine setting inputted on a particular day by the technician).  I was thinking if there was a way to loop through the machine settings of the found set and say count1 is the count where there is a machine setting properly inputted and count2 is when the field is blank, then after looping through all of the records I could take count2/count1 to get my completion percentage.  Is there an easier way to do this?  If not, what is the best way to write this script?