1,158
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
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
