Expand my Community achievements bar.

SOLVED

need help filtering for null or not null SFDC fields

Avatar

Level 6

I need to set up a multicondition filter that looks at three fields

 

The Sales Stage field CONTAINS Closed Won AND MA field IS NOT NULL AND VMA field IS NULL

OR

The Sales Stage field CONTAINS Closed Won AND MA field IS NOT NULL AND VMA field IS NOT NULL

 

To express IS NOT NULL, I've used 

  • does not exist
  • not equal to ""
  • not equal to " "
  • not equal to none
  • not equal to empty

None of these work.  Any suggestions?

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 9

Hi catherine,

 

The basic operator does not exist should be correct to check if not null.

 

Could you please post a screenshot of the whole filter?

 

Thanks in advance.

Regards

Lars

View solution in original post

2 Replies

Avatar

Correct answer by
Level 9

Hi catherine,

 

The basic operator does not exist should be correct to check if not null.

 

Could you please post a screenshot of the whole filter?

 

Thanks in advance.

Regards

Lars

Avatar

Level 6

Thanks @lgaertner I hadn't used Does Not Exist consistantly in my original test.  Correcting this solved the problem.


I appreciate the help!