Expand my Community achievements bar.

SOLVED

I'm having issues getting a custom field to do any calculation in a Report. Is my syntax correct?

Avatar

Level 3

displayname=Days on Hold
linkedname=project
namekey=view.relatedcolumn
namekeyargkey.0=project
namekeyargkey.1=Days Project Has Been On Hold
querysort=DE:project:Days Project Has Been On Hold
textmode=true
valueexpression=DE:project:Days Project Has Been On Hold + 1
valueformat=customDataLabelsAsString

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi,

 

The following text mode would do it:

 

displayname=Days on Hold
linkedname=project
namekey=view.relatedcolumn
namekeyargkey.0=project
namekeyargkey.1=Days Project Has Been On Hold
querysort=DE:project:Days Project Has Been On Hold
textmode=true
valueexpression=SUM({project}.{DE:Days Project Has Been On Hold},1)
valueformat=customNumberAsString

 

NOTE that the value format is "customNumberAsString" in my code, however in your original code it was customDataLabelsAsString. This suggests that the field has been set up as text format instead of number format. You're likely to find that mathematical expressions will not work with the field set at text.

 

Best Regards,

Rich.

 

View solution in original post

2 Replies

Avatar

Level 3

Is your custom field at the same object level as the report you are trying to display it on?

 

Just looking at it I am assuming this is a project-level custom field being pulled on a project-level report, but it doesn't hurt to ask!

Avatar

Correct answer by
Community Advisor

Hi,

 

The following text mode would do it:

 

displayname=Days on Hold
linkedname=project
namekey=view.relatedcolumn
namekeyargkey.0=project
namekeyargkey.1=Days Project Has Been On Hold
querysort=DE:project:Days Project Has Been On Hold
textmode=true
valueexpression=SUM({project}.{DE:Days Project Has Been On Hold},1)
valueformat=customNumberAsString

 

NOTE that the value format is "customNumberAsString" in my code, however in your original code it was customDataLabelsAsString. This suggests that the field has been set up as text format instead of number format. You're likely to find that mathematical expressions will not work with the field set at text.

 

Best Regards,

Rich.