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?