either of one

[smilingjohn]

Hi All, 

I need to have a table which will give me the output for the SalesID's for which the "RecievedID" or "DeliveredID" should not be null. 

I want to show those ID where Either Recieved ID or Delivered ID or both should have the number . 

I tried it using with Setb analysis . 

But this is giving me wrong data 

 Count({<Reeived_ID-={null},Delivered_ID-={null}>}SalesID) 

I need to use OR in set analysis Count OD sales ID where Delereved_ID is not null or Recieved _ID is not null 

This is not working for me ..Any help on this  

Thanks

Thanks in Advance

[Taoufiq_Zarra]

@smilingjohn  if I understood correctly you need the count of ID wich Received or Deliverd not null

you can use this :

=count({<[Sales ID]={"=len(trim([Received ID]))>0 or len(trim([Delivered ID]))>0 "}>} [Sales ID])

like this example :

[smilingjohn]

@Taoufiq_Zarra 

This dont work becuase in the script while loading the data i have converted empty and null values like below 

If(Isnull(  Recieved _D),'null',Recieved_ID) as Recieved_ID

If(Isnull(Delereved_ID ),'null',Delereved_ID ) as Delereved_ID 

Therefore the expression u stated in set analysis dont work . 

I need to specify something like this 

count(Delereved_ID -={'null'} or  Recieved_ID-={'null'}>}Sales_ID) 

IS this kind possible ? 

[Taoufiq_Zarra]

@smilingjohn  like this :

=count({<[Sales ID]={"=Match([Received ID],'null')>0 or Match([Delivered ID],'null')>0 "}>} [Sales ID])

output: