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)
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
kewills
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)
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.