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

[Priyanka_786]

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

[SAI_JAGADEESH15]

How can I store that value in a certain field such that it should be dynamic
Is this possible??

[Priyanka_786]

@SAI_JAGADEESH15 : No, it is not possible to store this value in certain field. However using GlideAggrigate API which provides all these functions is possible to store value in any field and use dynamically in the script.

If my response helps, please mark as helpful or accept the solution if it's serves the purpose 

Regards,

Priyanka