Line by line sum of the field.

[thead]

Hello,

I have a Report DataPage where in I need to get the total payment line by line. Please see below data for the sample output:

 

Is this possible to achieve?

[April]

Hi Thead,

In order to achieve that output, you need to add a calculated field on your Report DataPage. After you have added the calculated field use the below formula to get the sum line by line.

SELECT SUM(Payment) FROM Table WHERE ID<=  target.[@field:ID] AND Name=target.[@field:Name]

Note: Please change ID and [@field:ID]  to your unique field on your table.

Hope this helps.

[autonumber]

Hello - to know the list of functions that can be used within Caspio as well as sample calculations for reports, you check this article so you'll have a reference in case you will add or use more calculations in your application. 

https://howto.caspio.com/function-reference/

https://howto.caspio.com/tables-and-views/data-types/formula-fields/

https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/

[Flowers4Algernon]

Hello you may also refer to this link as this will be helpful in creating formulas/calculations: https://howto.caspio.com/function-reference/

[Queso]

Hi @thead, in case you don't know how April's solution works, you can visit the following website for definitions of SQL statements and functions: https://www.w3schools.com/sql/sql_select.asp