Good Morning,
I'm need the sum of a 'paymentdue' field based on the date range (criteria) selected by the end-user.
I'm currently using a sql select statement which is providing the grand total on the details page (formatted for use as the invoice). The sql statment is providing the grandtotal without any date criteria.
I need the grand total to change (increase amount or lessen amount) based on the end-user's date range selections.
Current Formula used in calculated field on details page:
select
sum(PaymentDue)
from Test_Table
where Name=target