0 Replies Latest reply: Nov 25, 2014 11:13 AM by Angel Serrano RSS

    Number of blanks and out of range per field

      Hi,

       

      I would like to create a table with the percentage of empty, out of ranges, and "Invalid format" records for all fields.

       

      For example, on the the following table I would like to create a chart with the Dimension fields (just 2 values - Age and Children), and the value of the expresions should be:

       

      - Empty = Age  20% // Children 20%

      - Out of ranges = Age  20% (considering averything less than 10 and over 100) // Children 10% considering over 20

      - Invalid format =  Age  10% (considering everyhing is not numeric) // Children 10% (considering everyhing is not numeric)

       

      Thanks in advance.

        

      EmployeeAgeChildren
      Emp148
      Emp2252
      Emp3 3
      Emp459 T
      Emp5372
      Emp6 2
      Emp7223
      Emp8£$55
      Emp9482
      Emp1019911