This content has been marked as final. Show 3 replies
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.