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}

else {@null}         *  

 

* '@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