3 Replies Latest reply: Mar 21, 2014 10:47 AM by Keith Jones RSS

    Missing, Blank and Null Values

      Hi there

       

      I am trying to provide a count of the missing, blank and null values in the attached Customer Address table.

       

      I have tried many on the helpful examples from the community but cant seem to get the result I expect or understand my results.

       

      I am simply adding Expressions in the List Box widget and had sucess with count min and max values.

       

      I am using the system value of $Fields in my expressions.

       

      In the data I would expect a 0 return for Address Number but 12 for 'Customer Address 1' field.

       

      Any suggestions and advice would be much appreciated.

       

      Thanks

       

      Keith