How to populate Sum/Avg/Max/Min value for specific List Column with configuration without any coding

Priyanka_786
Tera Guru
Tera Guru

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.

Priyanka_786_0-1735393320993.png

4. Check Total value box and click ok.

5. Total will get displayed for Business Elapsed time as per below

Priyanka_786_1-1735393776895.png

 

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

 

 

0 REPLIES 0