That was the second option I was considering to make the calculations
work faster--but there are multiple other fields other than day of
week, month and year that the data is getting sorted and compiled by
and all the intermediary calculations are of value in evaluating the
totals and other calculations that involve the intermediary sort
calculations--so not as simple as just re-doing a few links and
calculations at the upper level, unfortunately. However, I am not
ruling that option completely out.
Thanks,
Sue
On May 5, 2010, at 10:37 PM, richardsrussell tds.net wrote:
I may be totally misunderstanding the way you're doing this, but I
infer from what you wrote that you're aggregating a bunch of days
into a week, then aggregating those CALCULATED week totals into a
month, then aggregating those CALCULATED month totals into a year,
and so on.
If that's the case, it would probably be easier if you had
calculations within each record that simply spat out separate fields
for the week, month, and year numbers, then did the totals on each
of those individually.
For instance, today is 2010 May 5. If I create a record with that
date auto-filled, it could have calculated fields for Week = 18,
Month = 5, Quarter = 2, and Year = 2010. Then you could do your
sorting and totalling on ANY of those fields individually. Heck, if
you wanted to, you could even have a Weekday field that would let
you isolate all activities on Wednesdays (or any other day) for
subsequent analysis.
