# How to SUM the datalist?

**URL:** <https://community.yeeflow.com/t/how-to-sum-the-datalist/73>\
**Category:** Ask the community\
**Created:** [February 14, 2022, 6:42am UTC](https://community.yeeflow.com/t/how-to-sum-the-datalist/73 "2022-02-14T06:42:19Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![john55ww](https://avatars.discourse-cdn.com/v4/letter/j/b9e5f3/32.png) [@john55ww](https://community.yeeflow.com/u/john55ww)\
**Post date:** [February 14, 2022, 6:42am UTC](https://community.yeeflow.com/t/how-to-sum-the-datalist/73/1 "2022-02-14T06:42:19Z")

</div>

Hi,  
Some of us may have a massive records in one datalist.  
And we may try to extract some of the information from these datalist.

For example, I have 10 tasks for business A, and 4 of them are won.  
I want to get the number “10” and “4” here.

The usual method is using a Chart.

> **By Chart**
>
> I tried to make a chart including sub-category through a custom page but it seems hard to show the number of records set as “won”. (solution: I need to set a additional number fields(return 0 and 1 by condition) to count the “4” by “SUM”.)

The chart in custom page won’t provide any data.  
To get the counted “number”, they should be stocked in another datalist.

> **By Another Datalist**
>
> I create another datalist B. And a workflow in formal datalist(A) (triggered by both new or edit),  
> and ±1 the datalist B when the specific fields of datalist A changed, to accomplish the counting feature.  
> However, it will not triggered when record is deleted. So this method only support the datalist without delete.  
> Also, the workflow takes few seconds but user may need these reaction in shorter interval.

Neither of these method is perfect, is there any easier method in low-code?

---

<div class="post-metadata">

**Author:** ![frank](https://avatars.discourse-cdn.com/v4/letter/f/3d9bf3/32.png) [@frank](https://community.yeeflow.com/u/frank)\
**Post date:** [February 15, 2022, 3:18am UTC](https://community.yeeflow.com/t/how-to-sum-the-datalist/73/2 "2022-02-15T03:18:39Z")

</div>

Currently, there’s no easy way to get grouped count of one list and save to another list. We planed to provide more aggregate features to data list but it will not be ready very soon.

An idea is you have a workflow when an item created that add count to another list …

---

<div class="post-metadata">

**Author:** ![john55ww](https://avatars.discourse-cdn.com/v4/letter/j/b9e5f3/32.png) [@john55ww](https://community.yeeflow.com/u/john55ww)\
**Post date:** [February 16, 2022, 2:36am UTC](https://community.yeeflow.com/t/how-to-sum-the-datalist/73/3 "2022-02-16T02:36:50Z")

</div>

@frank Thank you for your suggestion.  
I do the same thing, but also I need to tell the user not deleting the records because deletion do not trigger the workflow lol.

---

<div class="post-metadata">

**Author:** ![frank](https://avatars.discourse-cdn.com/v4/letter/f/3d9bf3/32.png) [@frank](https://community.yeeflow.com/u/frank)\
**Post date:** [February 16, 2022, 11:03am UTC](https://community.yeeflow.com/t/how-to-sum-the-datalist/73/4 "2022-02-16T11:03:05Z")

</div>

Great! We often find that users are more creative with the system than we are with ourselves. BTW, you can try advanced permission of the list to avoid the deletion.