Can I get Caspio to total results in a column?

[aubreycohen]

I have a search and report data page that can return different combinations of product order totals (as in by product type, customer and year ordered). The last column is always the total number of products in each order (an order might be for one item or many). Can I get Caspio to add up the totals and deliver the total number of products ordered for that search result, as in the total number of orders in 2009 from a list that gives every individual order (again, an order could be one item or many) in 2009?

[bahar_vm]

Hi,

Calculations are not standard feature of Caspio however it is on the feature request list to be considered in future releases. At this time as a workaround solution you use Java Script programming to perform the calculation, here is a forum post which might be similar to what you are asking for, please check it out:

viewtopic.php?f=3&t=140&p=338&hilit=total#p338

Best,

Bahar M.

[aubreycohen]

Thanks. We got it to work.

[JolliBeng]

Hello aubreycohen,

You can now calculate the total of one column using Totals and Aggregation. See this  link for the details.

 

-JolliBeng

[NailDyanC]

Just to add, you may also use triggered action to calculate the total of one column. You may check the links below: