Can you display a calculated column at the grouping level in a report? | Community
Skip to main content
NickVa7
Level 9
Nov 23, 2020 7:11 PM UTC
Question

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

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

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    2 replies

    NickVa7Author
    Level 9
    Nov 25, 2020 4:06 PM UTC

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

    Translate
    kynabaker16
    kynabaker16
    Employee
    Nov 24, 2020 7:12 PM UTC

    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

    Translate
      Terms & ConditionsAccessibility statement

      Loading footer...