Forums: SUBTOTAL from TOTALS? - Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • This topic is locked

SUBTOTAL from TOTALS? Rate Topic: -----

#1 User is offline   VORONOY 

  • Member
  • PipPip
  • Group: Members
  • Posts: 24
  • Joined: 14-February 07

Posted 30 January 2018 - 02:18 PM

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!
0

#2 User is offline   admin 

  • Administrator
  • PipPipPip
  • Group: Admin
  • Posts: 15999
  • Joined: 03-February 03

Posted 15 February 2018 - 06:31 PM

This question didn't make much sense to me. Maybe a screenshot can help?
Best regards,
Sergey Kornilov
0

#3 User is offline   VORONOY 

  • Member
  • PipPip
  • Group: Members
  • Posts: 24
  • Joined: 14-February 07

Posted 28 February 2018 - 03:00 PM

View Postadmin, on 15 February 2018 - 01:31 PM, said:

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


Posted Image

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!
0

Page 1 of 1
  • You cannot start a new topic
  • This topic is locked