Re: Cant get my own subtotal
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 36574
interpreted = N
texte = Nitai @ ComputerOil 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 AventaggiatoAlternatively, you need some help in having per items discounts. ;~)Subtotal is a lot of work; it is not (IMNSHO) worth replacing it with your own. I have posted numerous times how I do discounts using another lineitem; this method works very well and then the built-in subtotal works fine.When you add an item that requires a discount, you have two choices:1) change the price calculation in the formulas.db to reduce the price by the discounted amount. The formula for price can be arbitrarily complex and can do [lookup]'s to several other tables to get the correct values.2) Add a second line item, with a negative price, that corresponds to the discounted amount. This is nice because then you can show both the original list price and the discount amount on the page. I usually do this only with an order level discount (so there is only 1 extra line item) but it is possible to do it at the item level too.Try to do a search on the archives (if they are up) for discussions on discounts and see how that goes. Otherwise, I'll see if I still have one of the old messages I can repost.John Peacock -- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747------------------------------------------------------------- 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 @ ComputerOil 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 AventaggiatoAlternatively, you need some help in having per items discounts. ;~)Subtotal is a lot of work; it is not (IMNSHO) worth replacing it with your own. I have posted numerous times how I do discounts using another lineitem; this method works very well and then the built-in subtotal works fine.When you add an item that requires a discount, you have two choices:1) change the price calculation in the formulas.db to reduce the price by the discounted amount. The formula for price can be arbitrarily complex and can do [lookup]'s to several other tables to get the correct values.2) Add a second line item, with a negative price, that corresponds to the discounted amount. This is nice because then you can show both the original list price and the discount amount on the page. I usually do this only with an order level discount (so there is only 1 extra line item) but it is possible to do it at the item level too.Try to do a search on the archives (if they are up) for discussions on discounts and see how that goes. Otherwise, I'll see if I still have one of the old messages I can repost.John Peacock -- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747------------------------------------------------------------- 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/
John Peacock
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:
generating unique IDs (2000)
Loosing Quantity (2000)
AuthorizeNet Declines (2005)
F3 crashing server (1997)
UPDATE PROBLEM (1997)
Uh...can someone help me out with the b10? (1997)
Help with a pull down menu (1999)
4.5.1 Upgrade... (2003)
[OT] ssh user@domain.com (2004)
Showif, Hideif reverse logic ? (1997)
Today's suggestions (1998)
Web Catalog 2 demo (1997)
Number searching/formats (1998)
Variable prices and Formulas.db (1997)
HELP! 10K hits per hour for pages that no longer exist! (2000)
Banners and sort of random display (1997)
Searching multiple Databases (1997)
[WebDNA] FreeBSD (2009)
Generating unique SKU from [cart] - FIXED! (1997)
lookup limitation ? (2003)