Expand my Community achievements bar.

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

Avatar

Level 10

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

2 Replies

Avatar

Employee

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

Avatar

Level 10

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