analliah
asked on
How to group based on a calcualted range / running total
I have to calculate a donor's frequency for the year. The frequency is not stored in the db so I have to create a running total which populatedthe freq # once the report is generated. Now where I'm having problem is trying to calculate how many donors fall under a certain range of frequency
A-2
B-1
C-3
D-1
E-1
basically it be
Freq 1 = 3 donor
Fre 2 =1 donor
Fre 3 = 1 Donor
A-2
B-1
C-3
D-1
E-1
basically it be
Freq 1 = 3 donor
Fre 2 =1 donor
Fre 3 = 1 Donor
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
the formula is not an options to group by. my FRQ formula is actually a running total and it's placed under GF1.
ASKER
@mlmcc
I kinda figured that was the problem. My work around is to export the data to access and create another report to read the export data again which allows me to do the grouping ( not user friendly) . And If the rpt is small I use nested select statement to give me the summary
Any suggestion what else I could do.
I kinda figured that was the problem. My work around is to export the data to access and create another report to read the export data again which allows me to do the grouping ( not user friendly) . And If the rpt is small I use nested select statement to give me the summary
Any suggestion what else I could do.
Did you try my idea on grouping by donor then sorting by the summary field?
You could use formulas and track how many of each number then print at the end.
If all you want is the summary then you can do it with formulas and don't put any fields on the report.
mlmcc
You could use formulas and track how many of each number then print at the end.
If all you want is the summary then you can do it with formulas and don't put any fields on the report.
mlmcc
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
1. Create a new formula called Donors type this code:
Whileprintingrecords;
Split({@FRQ},"-")[2]
2. Place the formula right beside the FRQ formula.
3. Right click on the new formula, Donors, choose Format Field and go under the Common Tab.
4. Check the Suppress selection to hide the formula.
5. Click okay.
6. Then click on the "Insert" menu on the top and select Group.
7. Select the Donors formula as the group by field
8. Done
Hope this helps.
P.