Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Jyoti Thorat (JyotiT46)
Tata Consultancy Services
Assistant Consultant
Tata Consultancy Services
IN
JyotiT46 Member since 2017 2 posts
Tata Consultancy Services
Posted: Sep 28, 2023
Last activity: Sep 28, 2023
Posted: 28 Sep 2023 13:20 EDT
Last activity: 28 Sep 2023 18:27 EDT
Closed

How to display sum of total rows at the bottom of report definition

Hi Team,

 

There is a requirement to fetch the report.  The report contains a column Which displays Amount.

The Total of all amounts should be added up and should display as TotalAmount at the end of report in bottom.

 

How can we achieve this using report definition.  Any suggestions to implement this functionality.

***Edited by Moderator Marissa to add Capability tags***
To see attachments, please log in.
Pega Platform 8.8.3
Reporting

Posted: 2 years ago
Updated: 2 years ago
Posted: 28 Sep 2023 18:22 EDT
Updated: 28 Sep 2023 18:27 EDT
Praveen Palagani (P.Siva.Praveen)
Infosys Limited
Senior Consultant
Infosys Limited
IN

@JyotiT46

There is an option in the report definition to use the custom section (in 2nd tab). In that, add the amount field and sum it.

Or use the agreegate function sum on the particular field so it would show the count on report itsself and on expanding you couuld see the list.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice