May 19, 2017 at 6:01 am
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
May 19, 2017 at 6:34 am
Yep, I don't know why I didn't think this way (feel stupid sometimes), but NULL values are not counted anyway so yes, thank you! Things are good.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy