OR command in set analysis

[#1]

Hello,

The following expression is working

COUNT({< ServiceDescription = {"Residential"},[CareEpisode
admissionDate] = {"<=$(=Date(vDate25thNov))"},

[CareEpisode
leaveDate] = {">=$(=Date(vDate25thNov))"} >}distinct [Client Res ID])

but I would like to add

an OR command

so leavedate => 25th Nov OR leavedate  is equal to '01/01/1900'

I know that the '+' sign is apparently used for OR in set analysis but I cannot get this to calculate at all.

Any ideas please?

Thanks.

[Anonymous]

COUNT({< ServiceDescription = {"Residential"},[CareEpisode
admissionDate] = {"<=$(=Date(vDate25thNov))"},

[CareEpisode
leaveDate] = {">=$(=Date(vDate25thNov)) =$(=makedate(1900,1,1))"} >}distinct [Client Res ID])

Use now, Hope it will help you out

[anbu1984]

COUNT({< ServiceDescription = {"Residential"},[CareEpisode
admissionDate] = {"<=$(=Date(vDate25thNov))"},

[CareEpisode
leaveDate] = {">=$(=Date(vDate25thNov)) <=$(=makedate(1900,1,1))"} >}distinct [Client Res ID])

[maxgro]

adapt to your requirement

=Sum( {$<d={"$(=max(d))"}+{"$(=min(d))"}>} Expression1)

good help here

Set Analysis: syntaxes, examples