Need help grouping calculated field

Forum|Forum|1 year ago
March 6, 2024
2 replies
1503 views

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!

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 KellieGardner

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...

KellieGardner

Community Advisor

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.

I

IsaDiAuthor

Level 2

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