Calculated field as filter in Live connection from Redshift

Hi,

We have a calculated field which combines two other fields like below

[Wellname] + " (" + [Api10] + ")"

However, when I use the above field as a filter it does not work. However, this works when connecting to a extract.

is this supposed to work with a live connection? Any more information on this would be really great.

Thanks.