Expression

[Anonymous]

Hi All,

I need a function to find certain text within the field. Let say I want to do a count base on field 1 and field 2 where string have the text "MANAGMENT" and "MGMT". It's not LEFT, RIGHT , or MID.

=Count({<{Field 1=, Field 2=}>}[Amount])

Field 1 ="489671467 TXYZ MANAGEMENT Inc"

Field 2 = "123567871467 WMZ MGMT Inc"

Many Thanks,

Frank

[rwunderlich]

=Count({<{Field 1={"*MANAGEMENT*"}, Field 2={"*MGMT*"}}>}[Amount])

[techvarun · Accepted solution]

     Count({<Field1 = {"*MANAGEMENT*"},Field2 = {"*MGMT*"} >}Amount)

[Anonymous]

Thanks Guys!