Re: Running subtotal?

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 18371
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.To get the date break, you would do a summary sort by date so that only unique dates are shown, then do a nested search inside that for each date the outer search finds.(untested) [search db=hours.db&equserdata=[username]&wdatesumm=T&aswdatesort=1] [FoundItems] Date: [wdate] [Search db=hours.db&equserdatarq=[username]&eqwdatedatarq=[wdate]] <-- this wdate comes from the outer search --> [math show=f]runningtotal=0[/math] [founditems][math show=f]runningtotal=runningtotal+[whours][/math][/founditems] [math]runningtotal[/math]
[/Search] [/FoundItems] [/search]Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Running subtotal? (Dave MacLeay 1998)
  2. Re: Running subtotal? (PCS Technical Support 1998)
  3. Running subtotal? (Gil Poulsen 1998)
  4. Running subtotal? (Gil Poulsen 1998)
>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.To get the date break, you would do a summary sort by date so that only unique dates are shown, then do a nested search inside that for each date the outer search finds.(untested) [search db=hours.db&equserdata=[username]&wdatesumm=T&aswdatesort=1] [founditems] Date: [wdate] [Search db=hours.db&equserdatarq=[username]&eqwdatedatarq=[wdate]] <-- this wdate comes from the outer search --> [math show=f]runningtotal=0[/math] [founditems][math show=f]runningtotal=runningtotal+[whours][/math][/founditems] [math]runningtotal[/math]
[/Search] [/FoundItems] [/search]Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ PCS Technical Support

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:

relogin same user? (1998) [OT] Search Engine Tips (2003) Running _every_ page through WebCat ? (1997) emailer (1997) WebCat b15 Mac plug-in (1997) multi-paragraph fields (1997) suffix mapping for NT? (1997) New public beta available (1997) Email Formatting (1998) Re:2nd WebCatalog2 Feature Request (1996) How to search for fields with 10 or more characters? (2004) Beta5??? (2000) Customizing WebDelivery.html (1998) Sorting by date (1997) $Quit, $CloseDatabase corrections (1997) Sort Order on a page search (1997) WebCat2: Items xx to xx shown, etc. (1997) [OT] Password protecting a folder in iTools (2003) Document Contains No Data! (1997) randomness (1997)