Running subtotal?
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 18317
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:
Emailer setup (1997)
Card clearance, problems - solutions? (1997)
Dealer locator (1998)
[sendmail] sending twice... (Update) (2003)
[GROUPS] followup (1997)
Introduction/Tutorial/QuickStart (1997)
comma-delimited email (1998)
test (2003)
Clear command and ShoppingCart.tmpl (1997)
Database Structuring (again) (2003)
WebCatalog-NT?'s (1996)
DIsplaying Search Result Relevance (2000)
[WebDNA] filter out the exclaimation point (2017)
Change to UPPERCASE (2000)
Multiple prices (1997)
WebTen? (1997)
Not really WebCat (1997)
WCf2 and nested tags (1997)
Caching [include] files ... (1997)
WebCat2b13MacPlugIn - more [date] problems (1997)