Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Calculated column (Concatenating two different custom fields) in Assignments report returns concatenation of a different field's data üòï

Avatar

Level 2

So I'm clearly doing something wrong..... but resorting to the forum for support as spent enough time in trial and error.

I have an assignments report and I want to concatenate the values in 2 custom fields as below.

valueexpression=CONCAT ( {DE:task:Task Type}, ' ' , {DE:task:Agile Task Type } )

linkedname=task

valueformat=customDataLabelsAsString

displayname=Type

namekey=view.relatedcolumn

textmode=true

namekeyargkey.0=task

namekeyargkey.1=Task Type

querysort=DE:task:Task Type

However what I see in the report column is Task Name, the space, then the Task Name again. I would expect the column to be blank if the formula was wrong.....

Have I got the DE and curly brackets wrong somehow? Separate, non calculated, standard mode columns for Task Type and Agile Task Type show exactly as expected in the report.

🤞 to see if the community can solve this one for me 🙂

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 10

Hi - you were very close. The trick is that you don't use the colon for reference in a value expression. You close the bracket around each object/field and put a period. (Also, there were a lot of spaces, but that might just be the paste job.

valueexpression=CONCAT({task}.{DE:Task Type},"",{task}.{DE:Agile Task Type})

linkedname=task

valueformat=customDataLabelsAsString

displayname=Type

namekey=view.relatedcolumn

textmode=true

namekeyargkey.0=task

namekeyargkey.1=Task Type

querysort=DE:task:Task Type

View solution in original post

2 Replies

Avatar

Correct answer by
Level 10

Hi - you were very close. The trick is that you don't use the colon for reference in a value expression. You close the bracket around each object/field and put a period. (Also, there were a lot of spaces, but that might just be the paste job.

valueexpression=CONCAT({task}.{DE:Task Type},"",{task}.{DE:Agile Task Type})

linkedname=task

valueformat=customDataLabelsAsString

displayname=Type

namekey=view.relatedcolumn

textmode=true

namekeyargkey.0=task

namekeyargkey.1=Task Type

querysort=DE:task:Task Type

Avatar

Level 2

Awesome @Anthony Imgrund‚ worked like a charm and don't know why I had not tried that permutation of brackets and periods!

Could not figure why returning values - expected a blank if there was an error.

If only text mode featured error checking - and even better some sort of field / object explorer.

Now on to the next issue with status displaying differently in a report than on the task!