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:
>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:
Need relative path explanation (1997)
Criticism of WebCatalog: Keep It Coming! (1998)
about this server and links to who (1997)
WebCatalog-NT?'s (1996)
how do you and/or in a search? (1997)
[WebDNA] Mailing list failure? Nope, Google SPAM control !!! (2019)
suffix mapping, use of cache, etc. (1997)
Balancing randomness (2000)
[OT] Mac OSX hardware test software (2004)
Problems passing [SKU] with $Replace in 2.0 (1997)
Converting SQL Microtime to Date and Time (2003)
Order not created error (1997)
Free WebDNA snippets (Extending WebCatalog) (1997)
Overridding E-Mailer (1998)
New York City sales tax database needed (1997)
Moment of Thanks (1997)
RE: [WebDNA] List Files question (2009)
show all problem (1997)
Multiple catalog databases and showcart (1997)
Problem with version 4 browsers (1998)