I think I need to convert the result of a calculation in to a text, but, can’t see how to do this.. Also, I assume that in CONCAT, the results of a calculation need to be converted to a string. I also think that a string of characters needs to be “abc”.
But, I cannot find a function that converts a number to s string.
Hi Karl,
You can use the FORMAT() function with a pattern to convert a number to a string. Then you can either use the CONCAT() function or just add them together with a + operator.
E.g. Full Name:
First Name + " " + Last Name
Or you can do:
CONCAT(First Name; Last Name)
It’s up to you.
Set the result type to Text.
.
