Skip to main content

Filter - Sum of Data

Allows you to calculate the sum of data in a number field.


How to Create a Sum Filter?

#1. Go to Filters

Open the collection in which you want to add a sum filter.

DrapCode Builder Sum Filter

#2. Name the Filter

Type the name of the filter and make it public by unticking the checkbox.

DrapCode Builder Sum Filter

#3. Select the Sum Filter

Choose Sum as the option from the dropdown list.

DrapCode Builder Sum Filter

#4. Select the Field

Choose the collection field whose data you want to add.

DrapCode Builder Sum Filter

#5. Add Condtion

Now add condition if you want and click the Create Filter button.

DrapCode Builder Sum Filter

How to Add a Sum Filter?

#1. Bind the Collection

Go to the page that contains a data table. Open the data table settings and bind the collection in which you have created the filter.

DrapCode Builder Sum Filter

#2. Drop a Text Field

Go to the components panel and drag-and-drop a text field that will show the added value.

DrapCode Builder Sum Filter

#3. Bind the Filter

Open the settings of the text component and bind the filter you had previously created.

DrapCode Builder Sum Filter

#4. Preview or Publish

Open the page in the preview or publish mode. The text field on which you had bound the sum filter would display the calculated sum of data under the field for which the filter was created, i.e. Bats (as per the example used).

DrapCode Builder Sum Filter