Running subtotal?
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 18370
interpreted = N
texte = Here's one that's way beyond my mortal abilities. I am trying to insert a running subtotal into a [foundItems] context that breaks at each date change and totals the hours for each date. The search at the bottom is hard-coded to return results for 6/12 just as a test. Anyway, since this output will encompass two weeks, perhaps three, of data, I cannot come up with a way to handle a running subtotal short of doing 14 separate [search] and [founditems] contexts, one for each date, and then 14 more for the running subtotals. Any insights would be much appreciated. (Note that I've adopted Ken's date storage and retrieval method here, which I highly recommend.) [search db=hours.db&equserdata=[username]&aswdatesort=1&max=500] [foundItems]
[format days_to_date %a][wdate][/format]., [format days_to_date][wdate][/format] | [ccode] | [lookup db=codes.db&lookinField=ccode&value=[ccode]&returnField=desc] | [whours] | [/foundItems] | Total hours for 06/12/1998: [search db=hours.db&equserdatarq=[username]&eqwdatedatarq=729917][math][founditems][whours]+[/founditems]0[/math][/search] |
-- Gil Poulsen, Webmaster************************************************************** * AltiM@c * Phone: (908) 222-9001 * * 111 Mali Drive * FAX: (908) 222-9002 * * North Plainfield, NJ * e-mail: help@altimac.com * * 07062-2355 * WWW: http://www.altimac.com * **************************************************************
Associated Messages, from the most recent to the oldest:
Here's one that's way beyond my mortal abilities. I am trying to insert a running subtotal into a [founditems] context that breaks at each date change and totals the hours for each date. The search at the bottom is hard-coded to return results for 6/12 just as a test. Anyway, since this output will encompass two weeks, perhaps three, of data, I cannot come up with a way to handle a running subtotal short of doing 14 separate [search] and [founditems] contexts, one for each date, and then 14 more for the running subtotals. Any insights would be much appreciated. (Note that I've adopted Ken's date storage and retrieval method here, which I highly recommend.) [search db=hours.db&equserdata=[username]&aswdatesort=1&max=500] [founditems] [format days_to_date %a][wdate][/format]., [format days_to_date][wdate][/format] | [ccode] | [lookup db=codes.db&lookinField=ccode&value=[ccode]&returnField=desc] | [whours] | [/foundItems] | Total hours for 06/12/1998: [search db=hours.db&equserdatarq=[username]&eqwdatedatarq=729917][math][founditems][whours]+[/founditems]0[/math][/search] |
-- Gil Poulsen, Webmaster************************************************************** * AltiM@c * Phone: (908) 222-9001 * * 111 Mali Drive * FAX: (908) 222-9002 * * North Plainfield, NJ * e-mail: help@altimac.com * * 07062-2355 * WWW: http://www.altimac.com * **************************************************************
Gil Poulsen
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Code sample - links.tpl (2002)
Large sites (2003)
XML Woes (2004)
f2 download problems (1997)
Searching multiple fields (1997)
WebCat2b12 - nesting [tags] (1997)
Showif date > other date (2004)
[ModDate] & [ModTime] ? (1997)
searching with if/then (2004)
$Replace with [founditems] (1997)
Extended [Concvertchars] needed (1997)
[WebDNA] Ubuntu 14 WebDNA FCGI suffix mapping for .html files (2020)
Webcat run amuk (2002)
filtering [founditems] (2004)
ServerQuestion (2000)
WebCat2b13MacPlugin - nested [xxx] contexts (1997)
stumped on simple sort (1999)
Problems when user hit back (2000)
webdelivery.html and webna (1997)
FTP and [shell] (2003)