Search the Community
Showing results for tags 'SQL SUM'.
Found 1 result
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)