comparing string to email field

[hopkinsc]

hi all. i am trying to compare a 'FirstName' field to an 'Email' field in a chart.

all i want to do is to check if the email field contains the first name but i cant get this to work.

does anyone have any ideas please?

[swuehl · Accepted solution]

Maybe something like

=Sum( If( Email LIKE '*'&FirstName&'*', 1,0))

Or use other string comparison functions like  Wildmatch().

But it's hard to suggest anything specific without knowing the context you want to use it (data model, chart dimensions / expressions etc.)

[hopkinsc]

thats great, thanks for your help Stefan. its the '*'&FirstName&'*' that i couldnt get right!

obvious now!