Forums: SUBTOTAL from TOTALS? - Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

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

#1 User is offline   VORONOY 

  • Member
  • PipPip
  • Group: Members
  • Posts: 20
  • 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: 15613
  • 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

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic