IF Contains

[beatrizmguerreiro]

Hello, 

I have a dataset similar to this and need to:

* Count the number of rows with the word "Fruit" and "Carbs"

* Sum the amount of requests, per type - also, need the date record as well

* Sum the price, per Type - also, need the date record as well

Date	Type	Amount of requests	Price
01/01/2020	Fruit Banana	20	10
03/01/2020	Fruit Apple	30	10
01/01/2020	Carbs Pasta	10	15
02/01/2020	Carbs Rice	10	15

Can you help me?

Thank you 🙂

[JulioMO · Accepted solution]

Hi @beatrizmguerreiro 

I've attached a workflow that performs what you want.

Hope it helps!

Regards

[Qiu]

@beatrizmguerreiro 

How do you want the Date Record to be shown for a Sum operation?

[beatrizmguerreiro]

@JulioMO 

It's working well. However, in my result I still can see different rows for Fruit Bananas and Fruit Apple. I needed these "merged" together", as fruit

[JulioMO]

In the second browse tool , you will see the results in the "merged form", since you are grouping by the Type_II field. That's the results you are looking for. 

However, if you want more details, in the third browse tool, you are also grouping by Type.

In your case, to see the results in the required form, you just need to pay attention to browse tool 1 and 2.

[Qiu]

@beatrizmguerreiro 

Like this format