• State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 4 replies
  • Subscribers 5 subscribers
  • Views 3890 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Reports

What is the best way to get a total/aggregate of the grid you are showing?

rachealv537

Hi! I have a report that aggregates a budget by client segment and returns the results in a grid. It works fine. However, I would like to add to my report the total for my grid at the top - not part of the grid- where I am going to add other text information. What is the best way to get a total/aggregate of the grid you are showing? Screenshot attached. Basically, a report total....

OriginalPostID-135924

OriginalPostID-135924

  Discussion posts and replies are publicly visible

Parents
  • 0
    I assume you have done something like this which should be alright.

              a!textfield(
                        label: "Total",
                        labelPosition: "ADJACENT",
                        readOnly: true,
                        value: dollar(sum(index(local!datasubset.data, "budgetEstimate", {})))
              )
Reply
  • 0
    I assume you have done something like this which should be alright.

              a!textfield(
                        label: "Total",
                        labelPosition: "ADJACENT",
                        readOnly: true,
                        value: dollar(sum(index(local!datasubset.data, "budgetEstimate", {})))
              )
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.