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:
creator code (1997)
[WebDNA] MailChimp (2012)
WebCat2: Formulas.db question (1997)
Server Freeze (1998)
WebCommerce: Folder organization ? (1997)
multi condition with showif (2005)
thread7715.debug (1999)
WebDNA deletes major DB data big time (2004)
frames & carts (1997)
NetSplat and WebCat2 (1997)
[/application] error? (1997)
Price Not Appearing (2000)
background (2001)
can WC render sites out? (1997)
Access Denied! But why? (1997)
WebMerchant (2000)
select multiple 2 more cents (1997)
Country & Ship-to address & other fields ? (1997)
WebCat2b15MacPlugin - [protect] (1997)
WebCat2: Items xx to xx shown, etc. (1997)