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.
User | Count |
---|---|
44 | |
29 | |
22 | |
20 | |
14 |