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 arunning subtotal into a [foundItems] context that breaks at each date changeand totals the hours for each date. The search at the bottom is hard-coded toreturn results for 6/12 just as a test. Anyway, since this output will encompass two weeks, perhaps three, of data, Icannot come up with a way to handle a running subtotal short of doing 14separate [search] and [founditems] contexts, one for each date, and then 14more for the running subtotals. Any insights would be much appreciated. (Notethat 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][formatdays_to_date %a][wdate][/format]., [format days_to_date][wdate][/format][ccode][lookupdb=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:

Re: Running subtotal? (Dave MacLeay 1998)
Re: Running subtotal? (PCS Technical Support 1998)
Running subtotal? (Gil Poulsen 1998)
Running subtotal? (Gil Poulsen 1998)

Here's one that's way beyond my mortal abilities. I am trying to insert arunning subtotal into a [founditems] context that breaks at each date changeand totals the hours for each date. The search at the bottom is hard-coded toreturn results for 6/12 just as a test. Anyway, since this output will encompass two weeks, perhaps three, of data, Icannot come up with a way to handle a running subtotal short of doing 14separate [search] and [founditems] contexts, one for each date, and then 14more for the running subtotals. Any insights would be much appreciated. (Notethat 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][formatdays_to_date %a][wdate][/format]., [format days_to_date][wdate][/format][ccode][lookupdb=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!

Running subtotal?

1998

Top Articles:

Related Readings: