How do I sum results?

[stevetimko]

I have a campaign database online that includes contributors, the candidate who received the money and how much money was given.

What I want to do is when someone searches by contributor or candidate (or both) I want the sum of the contributions to display.

I found this page. Or rather, someone in online chat helped me find it.

http://howto.caspio.com/datapages/creating-datapages/advanced-reporting/totals-aggregation.html

I can find the Data Page Elements Panel, but that's where I get stuck. What from the panel am I supposed to add? And what coding am I supposed to add after that, and where?

[casyana]

You have to add Total&Aggregation to your DataPage - use Insert dropdown below the DataPage Elements panel to insert Totals & Aggregation element, then choose field you want to sum from available fields in Aggregate options, and choose SUM function for it. See Aggregation section in this article:

http://howto.caspio.com/release-notes/w ... e-6-9.html

But, if I am not wrong Lite accounts doesn't have this feature enabled.

[Aether]

Hello @stevetimko,

You can also refer to this video tutorials in adding a SUM result in your reports DataPage:

 

I hope this helps  

~WatashiwaJin~

[Glitch]

It seems that the previous documentation was outdated.

Here's our new documentation about Totals and Aggregation : https://howto.caspio.com/datapages/reports/advanced-reporting/totals-and-aggregations/

Cheers