I have a report with a dataset that is returning records for ALL clients that have been served based on a start date and end date. It also returns the result of a question and subsequent formula for most, but not all (I did a left outer join), so some of the values in this field could be NULL. I hope what I need to do is very simple, but how would I do an expression for a textbox to display a count of those clients served that are NOT NULL? This would be a count of those clients who have that question answered. We are trying to actually determine a percentage of those total served / the number of those who did answer that question and get a ratio.
Thanks for the information