Table as a Filters

[#1]

I have two tables in a sample of information of all available data on the other I have a table of data that need to use as filters, that is, when I select the search field "Bodega" I should select all data containing the word in the description “Bodega“.

So I can get the total value of all descriptions that contain "Bodega" in their description.

I hope someone can help me.

Thanks and regards,

Enrique Quispe

[#2]

Hi

Try this expression

=COUNT(IF(Descripción LIKE '*BODEGA*', Descripción))

You can change '*BODEGA*' to GetFieldSelections([Campo Buesqueda], ',', 1)

[#3]

I try it,but it doesn’t work.  I attach anexample.

[#4 · Accepted solution]

Hi, see this example

[#5]

Thanks, this was what I needed.