Filter description based on keyword and sum the amount fields

[Vigneswaran]

Hi,

I want to find the description having the keyword "Rent" and sum the debit and credit amount for those description 

Input table:

Expected Table:

How can I achieve the new table
Thanks in advance!

[ShankerV]

Hi @Vigneswaran 

You can create a new column with Formula using Contains()

Then use the summarize tool to achieve result.

Many thanks

Shanker V

[Felipe_Ribeir0 · Accepted solution]

Hi @Vigneswaran 

One way of doing this

[ShankerV · Accepted solution]

Hi @Vigneswaran 

Expected solution

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V