Table Builder - Concatenate

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??


Please sign in to leave a comment.