Jump to content

Search the Community

Showing results for tags 'SQL SUM'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Caspio Bridge
    • General Questions
    • Caspio JavaScript Solutions
    • Tables, Views and Relationships
    • Import/Export and DataHub
    • DataPages
    • Deployment
    • Security, Authentications, Roles, SAML
    • Styles and Localizations
    • Parameters
    • API and Integration
    • Calculations and aggregations
    • User JavaScript and CSS Discussions

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start



Found 1 result

  1. Hello, I am using the following SQL statement to sum records from a view and it is working fine. I need to further refine this to only sum the data for a specific look up from the search page. I have tried passing parameters and several other things but I cant get it to work. Here is the statement I am using: (select sum(CaspioData_1_Agent_Time) from _v_prepaid) - CAST([@field:PrePaid_Credit] AS NUMERIC)