count two services occuring same time as one 1

[pruss]

I have not been able to write a formula correctly. I need to know how many clients receive Service 1 and service 2 simutaneously not add all clients who recieve service 1 and all clients who recieve service 2. In other words I don't want to add 1+1+2 I want 1+1=1.
Here is formula I was trying to alter.
if {CLTSVCAUTH.CSAS_LEVL_CODE}= "AIM" then 1 else
if {CLTSVCAUTH.CSAS_LEVL_CODE}= "RTM" then 1 else 0

sum({@Count AIM & RTM})

 

[lbass]

Do you have a datetime field that determines that activities are simultaneous? If so, you could group on {table.datetime} and then insert a distinctcount on the {table.clientID} field. Then each client would only be counted once per datetime group.

If this is not what you are trying to do, please explain a little more about the fields.

-LB