Filter Multiple Items at once

Hello,

I am trying to filter on journal category name first and filter on ces interface then I would like to then filter on the batch name and filter out unbilled or reverses. This is my input below. It is not getting me the correct result.

[Journal Category Name] = "CES Interface"

AND Contains([Batch Name],"Unbilled") OR Contains([Batch Name],"Reverses")

Custom Tools

Accepted answers

All comments

gabrielvilella

Hi @mprieto200, would you be able to provide a sample dataset?

mprieto200

These are the two columns I want to be filtered. I want it to filter out the first then move on to the next

Journal Category Name

CES Interface

Accrual

Batch Name

Reverses "CES Interface USD"23-OCT-21 00:54:54 - 96527864

Qiu

@mprieto200
The data is in two streams? or one whole file?

mprieto200

one file

ArtApa

Hi @mprieto200 - There are two ways to achieve your desired output:

1) Simply apply to filters.

2) Fix the logic in your conditional statement:

([Journal Category Name] = "CES Interface" AND Contains([Batch Name],"Unbilled"))
or
([Journal Category Name] = "CES Interface" and Contains([Batch Name],"Reverses"))

Both options are valid. I like more #1 as it is easier to understand.

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167