I am trying to pull information for a series of in...
# suiteanalytics
e
I am trying to pull information for a series of invoices in a saved search. How could I enter a string of doc id’s instead of doing a Document Number/ID = ???? OR Document Number/ID = ???? using expressions in the criteria filter? Thank you.
b
The direct method is to use a formula Add a standard filter criteria where the filter is a
Formula (Numeric)
filter where the formula set to
CASE WHEN {number} IN ('???0', '???1') THEN 1 ELSE 0 END
is
equal to
1
😀 1
e
Thank you so much @battk! I will try this.