How to populate Sum/Avg/Max/Min value for specific List Column with configuration without any coding
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-28-2024 05:51 AM
Dear Community,
Hope you are all doing great!!
Did you know that without any code you can configure Aggregate functions for any List/Related Columns values ? In this article, we will see on it. Let's get started !!
Requirement:- To populate Sum/Avg/ Min/Max value for specific List/Related list columns. These fields can be any Costing or Numeric fields.
Approach:-
1. Go to list view of table as per your need. Eg. task_sla
2. Go to the column where you need display aggregated value. Let's say in this example we want to display total of Business Elapsed time for specific incident.
3. Right click on the Business Elapsed time column- configure- List Calculations. You will get one popup as below.
4. Check Total value box and click ok.
5. Total will get displayed for Business Elapsed time as per below
Same Approach can be use to calculate Min/Max/ Average value. Also same way can be used for related list columns.
Please note that Aggregate functions (Sum/Min/Max/Average) options will be displayed as per Column field's datatype.
Hope it helps.
Please mark my post helpful/correct if you find this helpful.
Regards,
Priyanka Salunke
- 499 Views