Can you display a calculated column at the grouping level in a report? | Community
Skip to main content
N
NickVa7
Level 9
November 23, 2020
Question

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

  • November 23, 2020
  • 2 replies
  • 541 views

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

    kynabaker16
    Adobe Employee
    kynabaker16Adobe Employee
    Adobe Employee
    November 24, 2020

    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

      N
      NickVa7Author
      Level 9
      November 25, 2020

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

      Terms & ConditionsAccessibility statement

      Loading footer...