Calculated column (Concatenating two different custom fields) in Assignments report returns concatenation of a different field's data üòï | Community
Skip to main content
G
Greg__W
Level 2
April 23, 2021
Solved

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

  • April 23, 2021
  • 1 reply
  • 1110 views

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 :-)

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by imgrund

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

1 reply

imgrund
Adobe Employee
imgrundAdobe EmployeeAccepted solution
Adobe Employee
April 23, 2021

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

G
Greg__WAuthor
Level 2
April 23, 2021

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!

Terms & ConditionsAccessibility statement

Loading footer...