Custom record field query

Question

Hi, 
 I have created one custom record field where it calculated sum of all the event points present in the table.But I'm trying to display this data in the grid based on the date range selection so basically if that date range has only one row with event point = 10, it should display only row with value 10 but it is displaying the sum of all 100 rows in a single row. How to handle single row data calculation in appian records?

Shubham Aware · Answer

Don't use custom record fields for filtered aggregations, they calculate across entire dataset regardless of UI filters. https://docs.appian.com/suite/help/25.3/custom-record-fields.html?utm_source=chatgpt.com#sync-time-evaluations You can try below 2 methods. Display the source eventPoint field directly in grid and apply date range filters in a!recordData() query(custom fields bypass grid filters) Query filtered records using date filters, then calculate sum in the interface instead of custom field.

Harsha Sharma · Answer

I suggest you to move the logic to get sum of the points in the interface instead of the record. Custom Record field cannot relate to the filtered set by user , they work with entire dataset. 
 keerthis065835 said: How to handle single row data calculation in appian records