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 onlyunique dates are shown, then do a nested search inside that for each datethe 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][mathshow=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 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.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.To get the date break, you would do a summary sort by date so that onlyunique dates are shown, then do a nested search inside that for each datethe 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][mathshow=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 | Typhoon619/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)