I specifically needed one that returns true/false and only 1 value. FilterValues returns the value back.
Now that you say that, I guess no value/any value returned from FilterValues could be considered true/false.
Correct me if I'm wrong, but
FilterValues(valuelist; Value) = Value
does the same thing.
I don't think that will EVER return true. But
not IsEmpty ( FilterValues ( value ; valueList ) )
should be a simple enough alternative - unless one is looking for an exact match, in which case
Exact ( FilterValues ( valueList ; value ) ; value & ¶ )
could be used.
"I don't think that will EVER return true."
Almost correct, if value list and value are empty you can get a "true" but meaningless result :smileywink:
(I should know better than to respond to one of these without testing. :smileysad: )
On the other hand.
FilterValues(valuelist; Value) = Value & "¶"
will return 1 if true and 0 if false.
Somebody else recommended this:
getasBoolean( valueCount( filterValues( valuelist; value)))
that is overkill. Why put in another another function for evaluation when it doesnt need to be.
Michael's calc is correct and the one that you should use as the empty will return a boolean value.
Who is Michael?