I am trying to Concatenate two Text fields within the Table Builder. Here is my current formula.
=NP("Formula","CONCATENATE([@[No.]],"  ",[@[Name]])")
The result when I run the Table #VALUE!
The result I am looking for is 1000  Customer ABC
I have tried so many variations of this formula and cannot find the correct one. What am I doing wrong??
Table Builder  Concatenate
Re: Table Builder  Concatenate
Hello A1becker,
Please see a similar Community posting with an answer in the below link:
viewtopic.php?t=4478
Cheers,
Please see a similar Community posting with an answer in the below link:
viewtopic.php?t=4478
Cheers,
Re: Table Builder  Concatenate
Thanks for the link. I did "scour" this site for answers before I posted my question. That is why I copied the exact formula I entered into NAV. I am wondering if I am just missing some "," or ")" and do no see it.
Thanks,
Thanks,
Re: Table Builder  Concatenate
A1becker,
Did you get this resolved?
When I create this formula in Table Builder, I get the following:
=NP("Formula","concatenate([@[No.]],""  "",[@[Name]])")
This produces your desired results. Compared to your formula, mine has double quotes around the dash () where yours does not.
Regards
Did you get this resolved?
When I create this formula in Table Builder, I get the following:
=NP("Formula","concatenate([@[No.]],""  "",[@[Name]])")
This produces your desired results. Compared to your formula, mine has double quotes around the dash () where yours does not.
Regards
Re: Table Builder  Concatenate
krd1996,
thanks for the suggestion but I still get an error message. first I added another set of ("). That did not give me the correct results. Then I copied your formula and popped it into my Table. Still did not get the desired results.
Thanks for any suggestions you may have for me.
thanks for the suggestion but I still get an error message. first I added another set of ("). That did not give me the correct results. Then I copied your formula and popped it into my Table. Still did not get the desired results.
Thanks for any suggestions you may have for me.
Re: Table Builder  Concatenate
The formula, when in Excel should be =NP("Formula","CONCATENATE([@[No.]],""  "",[@[Name]])") with double quotes surrounding the .

 Posts: 1
 Joined: Fri Jun 16, 2017 12:09 am
Re: Table Builder  Concatenate
formula is working win 10 but not in win 7 .. I think you should try win 8 or win 10 to work as well.
Who is online
Users browsing this forum: No registered users and 1 guest