Re: taxTotal

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 14899
interpreted = N
texte = >Well, I figured out all of my problems with the [subTotal] and [grandTotal] >and such, yet I'm still having a problem with the [taxTotal] I'm using the >formulas from the tearoom, and on my purchace.tmpl page, WebCat is >returning the value for [ShipTostate] and [taxRate] (ca & 8.25) yet is >showing [taxTotal] as 0.00, from reading the book, is seems that if WebCat >is returning these two values correctly that it should calculate it also? > > >RayRay,for me, things don't always work as expected. I also had a problem with [taxTotal] on my second store. I was following the Tearoom example and I must not have had taxable set incorrectly. I came up with this workaround. I am not saying that this is the right way to do this. It is simply another way.Try this: substitute this $[format .2f][math][taxrate]*[subtotal]*.01[/math][/format] for [taxtotal]If webCat is returning the correct [taxrate] and your [subtotal] is correct, then this will work.Also you may wish to substitute a corresponding formula for [grandTotal] as I believe it relies on a correct [taxtotal] to get things right: $[format .2f][math][math][shippingtotal]+[subtotal][/math]+[math][taxrate]*[subtotal]*.01 [/math][/math][/format]Ken or Grant can probably tell you exactly how to do it correctly, but this should work (and I'm pleased with myself for figuring it out!).Paul _/_/_/_/_/_/_/_/_/_/_/_/|\_\_\_\_\_\_\_\_\_\_\_\_ _/_/_/Paul Uttermohlen, Internet Marketspace, Inc. \_\_\_\_ _/_/_/ mailto:paul@ims1.com - Website Development \_\_\_\_ _/_/_/ Business - _\_\_\_\_\_\_\_\_\_\_ _/_/_/ Real Estate - _\_\_\_\_ _/_/_/Websites - Children _/ _\_\_\_ _/_/_/_/_/_/_/_/_/_/_/_/_/_/ | \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ Associated Messages, from the most recent to the oldest:

    
  1. Re: TaxTotal (Donovan Brooke 2003)
  2. Re: TaxTotal (Kimberly D. Walls 2003)
  3. Re: TaxTotal (Kenneth Grome 2003)
  4. Re: TaxTotal (Glenn Busbin 2003)
  5. TaxTotal (Kimberly D. Walls 2003)
  6. Re: taxtotal question (John Peacock 2002)
  7. taxtotal question (Arturo Vargas 2002)
  8. Re: [taxTotal] question (John Peacock 2001)
  9. [taxTotal] question (Daryl Mitchell 2001)
  10. Re: [TaxTotal] (listas 1998)
  11. Re: [TaxTotal] (PCS Technical Support 1998)
  12. [TaxTotal] (listas 1998)
  13. Help with taxTotal calculation (Wayne Morishige 1998)
  14. Re: taxTotal confusion (charles kline 1998)
  15. Re: taxTotal confusion (PCS Technical Support 1998)
  16. taxTotal confusion (charles kline 1998)
  17. Re: taxTotal problem (Sandra L. Pitner 1998)
  18. taxTotal problem (Brian 1998)
  19. Re: taxRate is fine but taxTotal isn't (Michael Fichtenmayer 1997)
  20. Re: TaxTotal Problem (Kenneth Grome 1997)
  21. Re: TaxTotal Problem (Michael Fichtenmayer 1997)
  22. Re: TaxTotal Problem (Michael Fichtenmayer 1997)
  23. Re: taxRate is fine but taxTotal isn't (Kenneth Grome 1997)
  24. Re: TaxTotal Problem (Kenneth Grome 1997)
  25. Re: taxRate is fine but taxTotal isn't (Raymond Hatch 1997)
  26. Re: taxRate is fine but taxTotal isn't (Michael Fichtenmayer 1997)
  27. Re: TaxTotal Problem (Grant Hulbert 1997)
  28. Re: taxRate is fine but taxTotal isn't (Kenneth Grome 1997)
  29. TaxTotal Problem (Michael Fichtenmayer 1997)
  30. Re: TaxTotal Problem (Grant Hulbert 1997)
  31. taxRate is fine but taxTotal isn't (Michael Fichtenmayer 1997)
  32. Re: taxTotal, too (Janna S. Kohen 1997)
  33. Re: taxTotal (Raymond Hatch 1997)
  34. Re: taxTotal (Paul Uttermohlen 1997)
  35. Re: taxTotal (Raymond Hatch 1997)
  36. Re: taxTotal (Grant Hulbert 1997)
  37. taxTotal (Raymond Hatch 1997)
  38. taxTotal, too (Janna S. Kohen 1997)
  39. Re: [taxRate] [TaxTotal] ? (Jay Van Vark 1997)
  40. Re: [taxRate] [TaxTotal] ? (MallonT@aol.com 1997)
  41. Re: [taxRate] [TaxTotal] ? (Grant Hulbert 1997)
  42. RE: [taxRate] [TaxTotal] ? (Marc Eagle 1997)
  43. [taxRate] [TaxTotal] ? (MallonT@aol.com 1997)
  44. Re: taxTotal, grandTotal (Jeremy Pocock 1997)
  45. Re: taxTotal, grandTotal (Grant Hulbert 1997)
  46. taxTotal, grandTotal (Jeremy Pocock 1997)
>Well, I figured out all of my problems with the [subTotal] and [grandTotal] >and such, yet I'm still having a problem with the [taxTotal] I'm using the >formulas from the tearoom, and on my purchace.tmpl page, WebCat is >returning the value for [ShipTostate] and [taxRate] (ca & 8.25) yet is >showing [taxTotal] as 0.00, from reading the book, is seems that if WebCat >is returning these two values correctly that it should calculate it also? > > >RayRay,for me, things don't always work as expected. I also had a problem with [taxTotal] on my second store. I was following the Tearoom example and I must not have had taxable set incorrectly. I came up with this workaround. I am not saying that this is the right way to do this. It is simply another way.Try this: substitute this $[format .2f][math][taxrate]*[subtotal]*.01[/math][/format] for [taxtotal]If webCat is returning the correct [taxrate] and your [subtotal] is correct, then this will work.Also you may wish to substitute a corresponding formula for [grandTotal] as I believe it relies on a correct [taxtotal] to get things right: $[format .2f][math][math][shippingtotal]+[subtotal][/math]+[math][taxrate]*[subtotal]*.01 [/math][/math][/format]Ken or Grant can probably tell you exactly how to do it correctly, but this should work (and I'm pleased with myself for figuring it out!).Paul _/_/_/_/_/_/_/_/_/_/_/_/|\_\_\_\_\_\_\_\_\_\_\_\_ _/_/_/Paul Uttermohlen, Internet Marketspace, Inc. \_\_\_\_ _/_/_/ mailto:paul@ims1.com - Website Development \_\_\_\_ _/_/_/ Business - _\_\_\_\_\_\_\_\_\_\_ _/_/_/ Real Estate - _\_\_\_\_ _/_/_/Websites - Children _/ _\_\_\_ _/_/_/_/_/_/_/_/_/_/_/_/_/_/ | \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ Paul Uttermohlen

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:

default value from Lookup (was Grant, please help me) (1997) Linebreak as a delimiter in listwords? (2003) Keeping text formatting (like hard returns) (2002) eCommerce Idea Patented? (2002) [WebDNA] [BULK] [middle] behavior (2020) WebCat2 - [format thousands] (1997) Car Database (2002) ListFiles then delete by ModDate (2002) [WebDNA] Correct returnraw syntax? (2011) Lineitems [text*] (2004) showcart is slow (1998) Sort Order on a page search (1997) possible, WebCat2.0 and checkboxes-restated (1997) InternetWeek E-Commerce article (1998) Date comparison (I think) has bugs ... (1998) Tried installing Windows beta with no success... (2000) WebDNAReference (2000) attn: smitmicro - cart limitation (2002) Setting up shop (1997) search vs lookup (1998)