Yeah the original code didn't account for nulls but they did have 'convert nulls to default' on which sometimes works.
In response to your earlier reply: unfortunately no, In your example it counts the total clients if any Outcomes are not null. I need to count the number of clients for each Outcome where that Outcome is not null for a client.
For example, if I was to hard code it I would manually write out
"Outcome_1" and place distinctcount of the formula for the client count
[Formula code: OC_1_ClientCount]
if not isnull({OC_1})
then {Client_ID}
*
'@null' is a blank formula placed to remove the +1 count.
And then do the same for OC_2, OC_3, etc. down the list.
Does that make sense?
Thanks for your help with this wacky issue,
-Matt