This topic is locked

SUBTOTAL from TOTALS?

1/30/2018 9:18:48 AM
ASPRunnerPro General questions
V
VORONOY author

I have a table:
ID--DATE--RegHours--Overtime--PTO
For RegHours, Overtime, PTO columns I have TOTALS.
How I can do just one SUBTOTAL for all TOTALS at the bottom of the list page?
I tried to use snipped on list page, but its not working. I understand that snippets cannot read data. I cannot use Session variables in this scenario.
sql = "select SUM(ISNULL(RegHours,0) + ISNULL(Overtime,0) + ISNULL(PTO,0)) from Timesheet WHERE id='" & data("id") & "'"

set rstmp=CustomQuery(sql)

Response.Write rstmp(0)

rstmp.close

set rstmp=nothing
Thank you!

admin 2/15/2018

This question didn't make much sense to me. Maybe a screenshot can help?

V
VORONOY author 2/28/2018



This question didn't make much sense to me. Maybe a screenshot can help?



In this example I can only pull GRAND TOTAL After Record Added, but what I want to calculate Grand Total same way as 2 Weeks Total got calculated. (When I do Inline Edit - 2 Weeks Total getting updated on the fly, but Grand Total is not and I need to refresh the page.)
Thank you!