Hi all,
I have a custom field to show "Total Assets / Quantity Deliverable" in a request report (see attached). I would also like to group by this calculated field and see this in a chart.
Can this be accomplished?
Thank you!
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
The calculated field should be able to be grouped natively in your report and then referenced in your chart.
However, It appears these fields don't live on the "request" and actually live on the resolve project custom form, so you you'll have to do text mode for your grouping.
This is what it would like (not sure on the exact name of your fields)
group.0.displayname=TOTAL ASSETS / QUANTITY DELIVERABLES
group.0.valueexpression={resolveProject}.{DE:Estimated number of deliverables}
group.0.valueformat=doubleAsString
textmode=true
Once you apply the grouping it should show up in a report...
Views
Replies
Total Likes
Is this a calculated Column or a calculated field that lives on your custom form?
You can not group by text mode columns or use them in charts. If it's not already, I would suggest making this a calculated field you can capture on a custom form, then it can be used in reporting.
Views
Replies
Total Likes
Hi Kellie,
It's a Calculated field. I also created a calculated column, but I it's not working.
displayname=TOTAL ASSETS / QUANTITY DELIVERABLES
textmode=true
valueexpression=SUM({DE:resolveProject:Estimated number of deliverables},{DE:resolveProject:Estimated number of structure deliverables})
valueformat=HTML
Views
Replies
Total Likes
The calculated field should be able to be grouped natively in your report and then referenced in your chart.
However, It appears these fields don't live on the "request" and actually live on the resolve project custom form, so you you'll have to do text mode for your grouping.
This is what it would like (not sure on the exact name of your fields)
group.0.displayname=TOTAL ASSETS / QUANTITY DELIVERABLES
group.0.valueexpression={resolveProject}.{DE:Estimated number of deliverables}
group.0.valueformat=doubleAsString
textmode=true
Once you apply the grouping it should show up in a report...
Views
Replies
Total Likes
Thank you, Kellie! I appreciate the help!
Views
Replies
Total Likes
No problem. Hopefully it worked as expected.
Like the user below noted, if you want the field to calculate a sum or aggregate as a number in anyway, you would need to change the calculated field to be a number format vs a text format. Unfortunately, you can't do that after the field has been created and you'd have to recreate the field.
Views
Replies
Total Likes
If you create a calculated field on a custom form, rather than creating the custom field in the report, you will be able to group by it in a chart.
Views
Replies
Total Likes
Attached is the calculated field. I've not been able to group by this field in a chart.
Views
Replies
Total Likes
I believe the Format of the calculated field needs to be Number instead of Text.
Views
Replies
Total Likes