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.