Match with contains

[breno_morais]

Hello,

I have field 'Custo_Folha' with values and I need to take this values where 'Evento_Folha' contains name "HORAS EXTRAS", see:

Any help is appreciated

[Or]

Looks like you just need WildMatch() - what seems to be the problem?

[MarcoWedel]

Where do you need to take those values?

[swuehl · Accepted solution]

Use an aggregation function like Sum() or what is appropriate to 'take the values' with a set expression or an if() statement, something like

=Sum(If(Evento_Folha Like '*HORAS EXTRA*', Custa_Folha))

or

=Sum({<Evento_Folha = {"*HORAS EXTRA*"}>} Custa_Folha)

[breno_morais]

Thank you!! It's this