Joined: 25 Jan 2017
Location: United States
Online Status: Offline
Posts: 1
Topic: Summarizing Groups on Formual Field Posted: 25 Jan 2017 at 7:31am
I would like to summarize my Crystal Report by groups, on a formula field.
My report is grouped by "Estimated Family Contribution" and "Residency"(subgroup).
The formula field calculates the amount of aid awarded (it is calculated based on award term and award type).
I inserted a summary on the groups and first selected "sum." This returned the correct summed amount of aid awarded. However, when I edit the summary to return "median" Crystal doesn't seem to understand and returns incorrect numbers. What it seems to be doing, is only returning the median based on the grouping while ignoring the calculations I defined in my formula field.
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 25 Jan 2017 at 8:17am
Normally Crystal Reports do a aggregation based on where you are in the report. You can do running totals to override that a little bit. Otherwise you have to create your own aggravation in formulas. I haven't had to do a median since college, so that aggregation is a bit fuzzy for me.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
