Not isnull

[smilingjohn]

Hi Community,

I am trying to acheve the count of ID's  when two or one field is is not  null or not empty  for which i am using the below formula which is not giving me proper result . 

Can someone please correct me on this. 

if(not IsNull(DeptID) or not IsNull(CustomID),Count({<Region={'Newyor'},Priority={'High','Medium'}>}SalesID)).

Thanks

[Anil_Babu_Samineni · Accepted solution]

Perhaps this?

if(Len(DeptID&CustomID)>0 ,Count({<Region={'Newyor'},Priority={'High','Medium'}>}SalesID))

Or

Set Analysis

Count({<Region={'Newyor'},Priority={'High','Medium'}, SalesID={"=Len(DeptID&CustomID)>0"}>}SalesID)

[smilingjohn]

Thanks for the reply @Anil_Babu_Samineni 

sorry to say that your expression above is not working . 

I tried both the expression but i dont get the expected result 

[Chanty4u]

can you try this?

Count({<Region={'Newyor'},Priority={'High','Medium'}, SalesID={"=Len(trim(DeptID&CustomID))>0"}>}SalesID)

[Anil_Babu_Samineni]

@smilingjohn  If my expression not working, Why did you accepted my solution? If you have another work around, You can put that and mark that as answer ..

[smilingjohn]

@Anil_Babu_Samineni  Your second expression did work , and thats the reason i marked it as accept solution . 

Thanks