Can you display a calculated column at the grouping level in a report?

[NickVa1]

Hi WF Community,

I'm wondering if there's a way to display a calculated column at the grouping level in the Details tab of a report?

The result would be dividing the sum of two other columns. See attached screenshot to see what I mean.

• The Project: Record Count_Project field is a number field
• The Record Count_ITR field is a number field
• The ITR-to-Project-Rate field is a calculated column I created in the report, dividing the Record Count_ITR field by the Project: Record Count_Project field. I'd like to display this field calculation (ITR-to-Project-Rate) at the Project grouping level, similar to the other two fields with sums.

Thanks.

Nick

[kynabaker16]

Hi Nick!

I took this to some reporting whiz's and they said that what you're looking to do would essentially be called an "aggregator value in a Text Mode column" which is explained here in this article that is all about Conditional Formatting in Text Mode.

I don't have the exact text mode for you, but I'm hoping this gets you going in the right direction.

Kyna

[NickVa1]

Thanks for looking into this, Kyna. I'll try that out.