How should I create a calculated field for Vendor (VendorID):?
Here Vendor is the text (string) and VendorID is the GP field. Final result should be something like "ABC Company (123):". I am trying with string vendor ID and strip Vendor ID but it is not working. Any idea?
*This post is locked for comments