Case issue with joins

[caol69]

Hello

i was trying to join two tables with the link function but am having issues with the Case's for the fields im joining on.

one is Firstname.LASTNAME@company.com and the other table has firstname.lastname@company.com (all lower case)

is there a way to ignore case and focus on the content/values

i already tried to specify Upper {table1} = Upper {table2} in the formula workshop with no success

 

[kray4660]

I am not sure why the upper did not work for you. Did you put each field in a formula by itself and see what kind of results you got (i.e,. Upper({emailfield}) )

 

[caol69]

hi Kray4660, I tried to do as you suggested but it came up with the error message "a Boolean is required here"

any suggestions

 

[kray4660]

Are you putting the formula in the record selection part of the report? Just drop the formula in the body of the report (it is just for testing to see what the upper function is returning), not trying to filter yet.

 

[caol69]

Hi yes I was putting that formula in the record selection area.
I'm not to sure how to just drop the formula in the body as you said

 

[caol69]

I did create a formula field which was uppercase({emailid)} and put it in the body and this worked