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

Is it possible within Appian to effectively insert aggregated rows.

chrism967

Hi All,
We're looking to expand the use of Reports within Appian, however I'm looking to confirm if it's possible to effectively do row level calculations on the datasubset.

Eg imagine you have a P&L report which contains a grid with columns (month, year to date, vs last year, vs budget)

And Rows 4 rows of P&L summary lines (eg sales, discounts, cost of sales, profits)

Is it possible within Appian to effectively insert aggregated rows. Eg Row 1 =Sales, 2 =Discounts, 3 =net sales, 4 = 1-2- cost of sales = margin, 5= profit

The calcs aren't important, just the principle of cdt manipulation and not just appending a "total row" on.

Thanks

OriginalPostID-178750

OriginalPostID-178750

  Discussion posts and replies are publicly visible

Parents
  • 0
    Hello Chris, Assuming that you are trying to use a paging grid, I see only one possibility that being "creating a formatted cdt" with all the calculations prior to inputting it to the grid. Since there is no special ability built in to the grids to tell the columns to use a "formula" that works on other columns data for example. I worked on a similar use-case that aggregates data from processes and database and then shows final results on grid, here the grid only acts as a data render-er and does nothing special. On the other hand, implementing the same feature using an editable grid takes another approach. For this, I might not need any formatted cdt, as I can do all the calculations inside "row layout", which would have all the required data fields inputted to it, so I can write whatever formula for each cell inside THAT ROW itself. But for this we have to compromise built-in pagination. I might have misinterpreted your question but let me know you need any more information.
Reply
  • 0
    Hello Chris, Assuming that you are trying to use a paging grid, I see only one possibility that being "creating a formatted cdt" with all the calculations prior to inputting it to the grid. Since there is no special ability built in to the grids to tell the columns to use a "formula" that works on other columns data for example. I worked on a similar use-case that aggregates data from processes and database and then shows final results on grid, here the grid only acts as a data render-er and does nothing special. On the other hand, implementing the same feature using an editable grid takes another approach. For this, I might not need any formatted cdt, as I can do all the calculations inside "row layout", which would have all the required data fields inputted to it, so I can write whatever formula for each cell inside THAT ROW itself. But for this we have to compromise built-in pagination. I might have misinterpreted your question but let me know you need any more information.
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.