Concatenenat expression result for two columns of Ref Type

I have table SHIPPING in which column [Contract_#] of ref data type getting value from table CONTRACT and column [SKU_ID] also of ref data type getting value from table CONTRACT_DETAIL

Another column [ID] in SHIPPING table has got app formula CONCATENATE([Contract_#], " ", [SKU_ID])
The issue is that the result of this concatenate expression is giving the result where the value of column contract is twice

For example, if value of [Contract_#] is selected as ABC1234 from table CONTRACT and value of [SKU ID] from table CONTRACT_DETAIL is selected as RICE. The value of column [ID] in SHIPPING table is calculated as “ABC1234 ABC1234 RICE”

In fact, the value of [SKU_ID] in SHIPPING table is coming as “ABC1234 RICE” instead of “RICE”

Can I get some guidance that what could be the issue?

What is your initial value set to for [SKU_ID] in SHIPPING table?

"In fact, the value of [SKU_ID] in SHIPPING table is coming as “ABC1234 RICE” instead of “RICE” is most likely where your problem is.

From the sounds of it your CONCATENATE([Contract_#], " ", [SKU_ID]) should be correct.

1 Like