KNOWLEDGE BASE

Calculations Using Combined Fields are Invalid


Published: 23 Aug 2013
Last Modified Date: 07 Jun 2017

Issue

When creating a calculated field that uses a combined field, the calculation is not valid.

Environment

Tableau Desktop

Resolution

Concatenate the desired fields in the calculation using the "+" operator instead of using a combined field. For example: 
CONTAINS ([Product]+","+[Product Category],"Computer")

Instead of:
CONTAINS ([Combined Product Field],"Computer")

Cause

​Data is analyzed as either in/out of set, causing the results to be booleans instead of strings.
Did this article resolve the issue?