Re: Summing fields
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 10817
interpreted = N
texte = >> >I think it was mentioned once that it is possible to calculate a total>> >for a particular field over records in a database. What is the syntax>> >for doing this?>>>> <--starts a total variable at 0>> [FoundItems]>> >> [/FoundItems]>>>> If you view source you will see this generates a lot of HTML comments>>like with the intermediate results. You might also try>>>> [math]total=[FoundItems][field]+[/FoundItems]0[/math]>>>> This generates a single math equation that looks like total=5+9+4+49+7+96+0>Apparently both methods work cause I see the 's. The second>displayed the total as I wanted. How would I get the total to display>using the first method?If you remove the that surround the [math] context, it willdisplay all those intermediate totals. But if you want to display the grandtotal instead of the intermediate totals, you have to use the secondformula, or ...I created some WebDNA code using a separate database to calculate the totaljust once per day. This allows me to retrieve the total from the databaseinstead of recalculating it every time. If you want my code, just send meprivate email and ask ... :)Sincerely,Ken
Associated Messages, from the most recent to the oldest:
>> >I think it was mentioned once that it is possible to calculate a total>> >for a particular field over records in a database. What is the syntax>> >for doing this?>>>> [math]total=0[/math]> <--starts a total variable at 0>>
[founditems]>> [math]total=total+[field][/math]>>> [/FoundItems]>>>> If you view source you will see this generates a lot of HTML comments>>like with the intermediate results. You might also try>>>>
[math]total=
[founditems][field]+[/FoundItems]0[/math]>>>> This generates a single math equation that looks like total=5+9+4+49+7+96+0>Apparently both methods work cause I see the 's. The second>displayed the total as I wanted. How would I get the total to display>using the first method?If you remove the that surround the
[math] context, it willdisplay all those intermediate totals. But if you want to display the grandtotal instead of the intermediate totals, you have to use the secondformula, or ...I created some WebDNA code using a separate database to calculate the totaljust once per day. This allows me to retrieve the total from the databaseinstead of recalculating it every time. If you want my code, just send meprivate email and ask ... :)Sincerely,Ken
Kenneth Grome
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:
Has this happened to you? (was:Emailer Chokes on bad address) (1997)
Newbie Tax Question (1997)
Generating Report Totals (1997)
date display (1999)
WebCatalog can't find database (1997)
Error Lob.db records error message not name (1997)
2.0 Info (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
Closing Databases (1998)
Uploading under Windows (2001)
Problems setting MIME Headers (1998)
Error 551 in Emailer (2000)
HELP WITH DATES (1997)
default value from Lookup (was Grant, please help me) (1997)
[WebDNA] Google Maps (2019)
New [If] command question + New Feature Request (2000)
How to Display text in empty fields (1997)
WebCatalog 4.0.1 has been released! (2000)
OT: WebDNA and LINUX (2004)
[WebDNA] Technical References (2009)