Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Count({<Field1 = {"*MANAGEMENT*"},Field2 = {"*MGMT*"} >}Amount)
=Count({<{Field 1={"*MANAGEMENT*"}, Field 2={"*MGMT*"}}>}[Amount])
Count({<Field1 = {"*MANAGEMENT*"},Field2 = {"*MGMT*"} >}Amount)
Thanks Guys!