Jack94 Posted October 31, 2022 Report Share Posted October 31, 2022 Hi, I have a table with 4 fields: Name, Surname, ID and Customer_concat. Customer_concat field is a formula: [@field:surname] + ' ' + [@field:name] + ' ' + CAST([@field:ID] as VARCHAR) Why when I create a pivot datapage I don't see this field in the row value? Quote Link to comment Share on other sites More sharing options...
0 autonumber Posted November 5, 2022 Report Share Posted November 5, 2022 Hi @Jack94 - can you try this formula instead? CONVERT(VARCHAR,[@field:surname] + ' ' + [@field:name] + ' ' + CAST([@field:ID] as VARCHAR)) You might need to convert the whole formula for you to be able to select it as a row in your pivot datapage. Quote Link to comment Share on other sites More sharing options...
Question
Jack94
Hi,
I have a table with 4 fields: Name, Surname, ID and Customer_concat.
Customer_concat field is a formula:
[@field:surname] + ' ' + [@field:name] + ' ' + CAST([@field:ID] as VARCHAR)Why when I create a pivot datapage I don't see this field in the row value?
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.