"OR" criteria for summary field?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I would like to be able to specify "OR" conditions for a summary field. Specifically, I am trying to total values where a text field contains either of two words. Is there a way to do this?

Thanks,

Michael

Photo of Michael

Michael

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Indeed there is

If you type OR in upper case, then it will treat that as an OR opposed to a random text string.

for example


[Ingredients] Contains mustard OR ketchup 

will get a hit on either of those ingredients.

but on the other hand 

[Ingredients] Contains mustard or ketchup 


will only get a hit if the ingredient is actually named "mustard or ketchup" (as if that is how it was labelled on the supermarket shelf, like a random contents purchase).
Photo of Michael

Michael

  • 0 Points
Thank you so much for the quick reply! I did not realize that made a difference!
Apparently Google uses the same convention.  You can search on cats OR dogs and get hits on either in a compound search.