Hello guys, I hope you'll be able to help me. I'm having a problem filtering NL formula if it refers to the options selection if a list of values is selected. For example, in the options tab if I type A|B and then in NL formula I have NL("Sheets","Job","No.","Name Project Manager",$C$2) where C2 is A|B - the formula works. If I run the report and select A|B then the formula breaks as the value in C2 is ="A|B". Please, help me to avoid the error.
Daniel
Date
Votes
3 comments
-
CascadiaDataworks Are you getting a #VALUE? If so, highlight the cell and click on Check Error in the menu. What is the message that is displayed?
-
Daniel Ahchiev The error is in the value. Jet is considering "A|B" as a single value as converted as text. It probably should be "A"|"B".
-
CascadiaDataworks Are you able to provide the actual value you are using as a filter? Is it A|B or are they other values? If there are special characters or some other factors, it could affect the filter but if you just have A|B, there shouldn't be a problem.
Please sign in to leave a comment.