Post reply

Counting if not null

  • May 19, 2017 at 6:01 am

    #342929

    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:20 am

    #1943278

    If they do contain NULLs then perhaps:
    =COUNT(Fields![Your Nullable Column].Value, "[Your dataset Name]")

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.

  • May 19, 2017 at 6:34 am

    #1943280

    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