Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Report last 12 months only in formula?
Message
General information
Forum:
Visual FoxPro
Category:
Crystal Reports
Miscellaneous
Thread ID:
00693681
Message ID:
00696841
Views:
20
Steve,

I assume you have date fields in the table you are working with. Have you tried creating a running total field and using a formula field under the "Evaluate" section? That way you can conditionally have the total field accumulate based on your date range condition.

Laterness,
Jon


>I have the following formula in my group totals section of my Crystal Report.
>I am simply adding one total to another total.
>How can I change this formula to only had totals for the last 12 months and not all totals for all dates and times?
>
>@attempts is the name of the formula
>
>Sum ({tubestats.o_att}, {@medicname})+Sum ({tubestats.n_att}, {@medicname})
>
>Thanks!
Jon Rosenbaum
Devcon Drummer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform