View the original community article here
Last tested: Jan 21, 2019
This can happen when creating an IF( ) statement in Table Calculations that have different datatype results. For example:
Where order_items.count is an integer value, but the other IF conditions output strings like row 1 or row 2. To resolve this we need to ensure that all data type outputs of the IF statement match. This is very similar to how a CASE WHEN will work in SQL.
"else string value"))