Filtering with certain criteria

Hi Community,

I would like to ask how should i create workflow or make formula if i only want to filter two items : I and C as per screenshot below :

In the screenshot below, there are three items under TransactionType column : I, C and P. However, i only want the information related to I and C. P will be excluded.

Do anyone have any idea how to make this workflow?

Common Use Cases

Accepted answers

Emil_Kos

Hi @SH_94,

In that case, you don't need a formula. You can easily identify the filter tool in order to achieve your goal:

Alternatively, you can write:

[Transactional Type] != "P"

Does not equal.yxmd

AngelosPachis

@SH_94 you can also use a filter tool as @Emil_Kos , but then also make use of the expressions we introduced earlier.

For example, if you have different transaction types as shown below

you can use either the OR expression or the IN function to filter out transaction types "I" and "C"

I have done both so you can see that the outcome is the same, although the expression changes. Just check the T output anchor of the filter tools

example.yxmd

All comments

Emil_Kos

Hi @SH_94,

I believe this formula should help you:

[Transactional Type] IN ('I','C')

Transactional Type.yxmd

SH_94

Hi @Emil_Kos ,

Thanks a lot for the workflow shared.

I would like to ask about the formula = [Transactional Type] IN .Let said today i had multiple of items in the Transaction type column and i want to filter out P only. Is it i make the formula as below:

[Transactional Type] OUT ('P')

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703