Formula Question
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 16727
interpreted = N
texte = I have a situation that requires a special calculation of the [subtotal] based on various date and dollar amount variables.It seems to me that this should be simple to pull off automatically in the formulas.db, but I have not been able to make it work. It's starting to not look so simple. HELP.Here's what I need to do:Orders placed by June 1, 1998, deduct 8% Orders placed by September 1, 1998 deduct 5% Orders placed by November 1, 1998 deduct 3%and also...Orders over $1,000.00 deduct 3% Orders over $2,000.00 deduct 5% Orders over $3,000.00 deduct 3%All of the above variables need to be checked and executed if they match. Has anyone tried to do anything like this, and if so please guide me in the right direction. I would be most grateful and will not have to lose anymore hair over it.Thanks,David T. Horn
Associated Messages, from the most recent to the oldest:
| |
- Formula Question (David T. Horn 1998)
|
I have a situation that requires a special calculation of the [subtotal] based on various date and dollar amount variables.It seems to me that this should be simple to pull off automatically in the
formulas.db, but I have not been able to make it work. It's starting to not look so simple. HELP.Here's what I need to do:Orders placed by June 1, 1998, deduct 8% Orders placed by September 1, 1998 deduct 5% Orders placed by November 1, 1998 deduct 3%and also...Orders over $1,000.00 deduct 3% Orders over $2,000.00 deduct 5% Orders over $3,000.00 deduct 3%All of the above variables need to be checked and executed if they match. Has anyone tried to do anything like this, and if so please guide me in the right direction. I would be most grateful and will not have to lose anymore hair over it.Thanks,David T. Horn
David T. Horn
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:
$Quit, $CloseDatabase corrections (1997)
Replace context (1998)
OLD PROBLEM (1997)
Field value disappearing problem (2003)
SSL and reg web* (1997)
[Feature Request] Stronghold security variables that cannot be (2000)
Database Security (1998)
Multiple prices (1997)
[WebDNA] Snow Leoopard and v7 (2011)
I have observed and I am gone. (1998)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
PIXO support (1997)
WC3 and SSL on NT (1998)
Summing fields (1997)
Quickie question on the email templates (1997)
[WebDNA] Clean URLS job - will pay (2010)
Bug in 4.5 - Needs to be fixed ASAP. (2002)
Dumb Question about Docs (1997)
Resetting a Formvariable (2000)
WebMerchant when CC network is down (1998)