I am trying to accomplish this:
=NL("Count","Table",,"=OR(NF(,""Field1"")=""value"",NF(,""Field2"")=""value"")",TRUE)
where Field1 is a boolean. I'm not sure what to enter for "value". I've tried:
NF(,""Field1"")=""True""
NF(,""Field1"")=""TRUE""
NF(,""Field1"")=""1""
and none of them evaluate to true. When I replicate the rows, excel displays TRUE for those field values, so #2 seems likely, but it still doesn't work. Please help.
Thanks in advance.
Date
Votes
3 comments
-
Jet Reports Historic Posts Official comment Did you try TRUE without the quotes? I believe in Excel true and false don't need quotes so possibly something like this would work:
=NL("Count","Table",,"=OR(NF(,""Field1"")=TRUE,NF(,""Field2"")=TRUE)",TRUE)
Does that work for you?
Regards,
Hughes -
Jet Reports Historic Posts I haven't yet. When I am able to get back to it I will try it. Thanks again.
-
Jet Reports Historic Posts That was it. I assumed all fields needed to be in double quotes. Clearly this is not the case.
Please sign in to leave a comment.