Bobby,
Yes you can use both "regular" filters and a filters= in the same function and all filters will be applied. I assume you are asking this because some of your filters need to change with replicated values whereas some of your filters are coming from an option sheet or are a constant value. Yes you should be able to do this.
Regards,
Hughes
Date
Votes
5 comments
-
Jet Reports Historic Posts Official comment Hi Bobby,
In order to use more than 10 filters in an NL function, you will need to use Filters=, which takes an array of filters. So you might put your filters on the report like this:Column C Column D Row 3 Field1 Filter1 Row 4 Field2 Filter2
Then you could do this in your NL function:=NL("Rows","Table",,"Filters=",$C$3:$D$4)
With that structure, you can add more than 10 filters. Does that work for you?
Regards,
Hughes -
Jet Reports Historic Posts Hi community,
Does anyone know of a way to have more than 10 filters on an NL function? I tried just adding commas at the end of the formula, and adding my filters there, but it returns a #VALUE when I do that.. Any ideas?
Thanks
Bobby -
Jet Reports Historic Posts Thank you so much. I think that might work but in that case are we allowed to do something like this:
=NL("Sum","G/L Entry","Amount","Posting Date",G$8,"G/L Account No.",$D34,"Fund No.",$E$21,"Filters=",$B$2:$C$14))
In other words, is it allowed to use a combination of both types of filters (the regular one, and the array one?)
Thank you
Bobby -
Jet Reports Historic Posts Thanks for your insight Hughes. I will try it and reply here with the results
Bobby -
Jet Reports Historic Posts I can confirm that everything worked as discussed. Thanks so much
Bobby
Please sign in to leave a comment.