Re: Cant get my own subtotal
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 36571
interpreted = N
texte = Nitai:Not sure if this is what you're looking for. But this is the way I get subtotals: In this particular example, I'm getting a subtotal for each organization([org]) that occurs in a registration file. I could just as easily be subtotaling a field by adding the field to runningsubtotal instead of 1.[search db=../someDB.db&neOrgdata=find_all&orgSumm=T&orgsort=1] [foundItems] [search db=../someDB.db&eqOrgdata=[org]] [math show=F]runningsubtotal=0[/math] [foundItems] [math show=F]runningsubtotal=runningsubtotal+1[/math] [/foundItems] [math]runningsubtotal[/math] [/search] [/foundItems] [/search] At 02:42 PM 6/22/01, you wrote: >Sorry need to rephrase the question. > >I need to get some lead to HOW this is to be done. > >I need my own subtotal math because I am using some discount on each item >and the build-in subtotal adds everything up without subtracting the >discounts. > >Sincerely, >Nitai Aventaggiato > >> Just a thought... are you perhaps using one of the reserved words and >> confusing WebCat? >> >>> Hi all, >>> >>> Sleepless night, so please be nice:-) >>> >>> I am trying to get my own subtotal to work. I have different currencies with >>> different taxes. Anyhow, all I need to know how I can create my own >>> subtotal (same for grandtotal). >>> >>> I have tried to write each lineitem to a temp.db and sum it all up, but can >>> get it to work. >>> >>> I would really appreciate any comment or snippets of code. Thank you all. >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list
. >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to >> >> Web Archive of this list is at: http://search.smithmicro.com/ > >-- >We make tools to energize your business >Content Management & eBusiness Systems > >ComputerOil GmbH http://computeroil.com >Hauptstrasse 12 info@computeroil.com >8252 Schlatt/Switzerland >Tel: +41 (0)52 654 15 55 > > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to >Web Archive of this list is at: http://search.smithmicro.com/ > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Nitai:Not sure if this is what you're looking for. But this is the way I get subtotals: In this particular example, I'm getting a subtotal for each organization([org]) that occurs in a registration file. I could just as easily be subtotaling a field by adding the field to runningsubtotal instead of 1.[search db=../someDB.db&neOrgdata=find_all&orgSumm=T&orgsort=1] [founditems] [search db=../someDB.db&eqOrgdata=[org]] [math show=F]runningsubtotal=0[/math] [founditems] [math show=F]runningsubtotal=runningsubtotal+1[/math] [/foundItems] [math]runningsubtotal[/math] [/search] [/foundItems] [/search] At 02:42 PM 6/22/01, you wrote: >Sorry need to rephrase the question. > >I need to get some lead to HOW this is to be done. > >I need my own subtotal math because I am using some discount on each item >and the build-in subtotal adds everything up without subtracting the >discounts. > >Sincerely, >Nitai Aventaggiato > >> Just a thought... are you perhaps using one of the reserved words and >> confusing WebCat? >> >>> Hi all, >>> >>> Sleepless night, so please be nice:-) >>> >>> I am trying to get my own subtotal to work. I have different currencies with >>> different taxes. Anyhow, all I need to know how I can create my own >>> subtotal (same for grandtotal). >>> >>> I have tried to write each lineitem to a temp.db and sum it all up, but can >>> get it to work. >>> >>> I would really appreciate any comment or snippets of code. Thank you all. >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to >> >> Web Archive of this list is at: http://search.smithmicro.com/ > >-- >We make tools to energize your business >Content Management & eBusiness Systems > >ComputerOil GmbH http://computeroil.com >Hauptstrasse 12 info@computeroil.com >8252 Schlatt/Switzerland >Tel: +41 (0)52 654 15 55 > > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to >Web Archive of this list is at: http://search.smithmicro.com/ > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Sally Reidy
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:
WebCatalog NT beta 18 problem (1997)
Almost a there but..bye bye NetCloak (1997)
Formulas.db (1997)
syntax question, not in online refernce (1997)
Migrating to NT (1997)
Answer: WebDelivery downloads alias, not original ? (1997)
I'm new be kind (1997)
Using Plug-In while running 1.6.1 (1997)
Updating checkboxes made easy !!! (1998)
Questions about maximum (1999)
[WebDNA] Downloading and combining RSS feeds (2012)
check out page (SSL) *still* not loading on Netscape 4.0+ (1999)
User Defined Sorting (1997)
Move WebDNA DB to MySQL (2005)
WebCatalog2 Feature Feedback (1996)
WC2.0 Memory Requirements (1997)
[ShowNext] feature in 2.0 (1997)
Site / Database Structure (2002)
Date/Time format problems (1997)
[WebDNA] sort parameters in search (2015)