Set Analysis - AND condition

[#1]

Hi,

Please help me to get the count of Id's which have the records in Either 'On Hold' column OR 'Cancelled' Column...

I wrote the expression as below, but it is giving me only the data based on AND condition

Count({$<Month={'31/01/2013'},[On Hold]={1},[Cancelled]={1}>}[ID])

Please suggest me...

[#2]

Hi,

Please can you attach your sample application ?

[Sokkorn]

Hi,

Try this Count({<[On Hold]={1}>+<[Cancelled]={1}>} [ID])

Regards,

Sokkorn

[#4]

Try this:

Count({$<Month={'31/01/2013'},[ID]={'On Hold','Cancelled'}>}[ID])