View Full Version : Calculating Current Year's Total


Raheel Ahmed
02-25-2005, 12:34 PM

I have searched through the phorums for any hints on how to calculate a year to date total but have failed to find a solution.

Has anyone ever used a year to date total before?

I have numeric fields that need to be calculated into year to date totals on a report.

What I want to be done is so simply done by calculating a sum of the columns on an excel sheet but I cant transform my thoughts into the Alpha db. Any help or suggestions would be helpful.

I am working on a zip file to include for my specific case. In it I have also attempted a run_total() function but it is not working to calculate the current year's total of that field...in the meanwhile please help me with any suggestions that u may have...

Stan Mathews
02-25-2005, 01:40 PM
Many records - use dbsum() fter creating an index on year(datefield)

Few records - use tablesum() with a year(datefield) = some_number filter