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
Create a string calculated field of STRIP(Vendor Name) # ( # STRIP(Vendor ID) # )
Where # is the CAT (concatenate) button.
and the ( and ) are string constants
Regards
David
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,188 Super User 2024 Season 2
Martin Dráb 230,030 Most Valuable Professional
nmaenpaa 101,156