AnsweredAssumed Answered

Count of fields IsEmpty vs Total count of All fields (Each Record)

Question asked by RickM_1 on Oct 2, 2012
Latest reply on Oct 2, 2012 by philmodjunk

Title

Count of fields IsEmpty vs Total count of All fields (Each Record)

Post

     I am new to FM (1 day). I am trying to count the number of fields in each record where the field value is empty. Then compare that to the total number of fields in the record and return a % of completed fields. I want to report on the records where not all fields have been completed. I am importing in the records so I cannot mandate the fields be filled in.

      

Outcomes