• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 600
  • Last Modified:

Crystal XI - Summarizing on formulas with groupings

I am trying to create a count on how many employees are in a wage bracket based on their job title.  I have groupings on the formulas for the wage brackets.  When I try to summarize the count I am receiving a message that I cannot summarize on a certain formula.  How do I get beyond this issue.

Formulas for Minimum, Mid and Maximum, plus 1st Quartile, 3rd Quartile and Median based on formula within for Total Annual Salary and grouping.

I have a created a formula (1st Quartile Count) to do a count on the employees within the brackets (IF Then Else) for a count of 1, but when I try to summarize the count I either cannot do it on Summary or with a formula (1st Quartile Total Count) receive a message I cannot summarize the field.  I need a count on each quartile and by Job Code.

see attached report and report definition.txt.
Salary-Structure.rpt
salary-structure.txt
0
Grapelady
Asked:
Grapelady
  • 3
  • 3
1 Solution
 
mlmccCommented:
The problem is twofold.

1.  You can't use a summary on a formula that uses a summary.
2.  Minimum and Maximum are printtime and in general can't be summarized.

You will have to use formulas and variables

mlmcc
0
 
mlmccCommented:
Here is a first stab at it.

You need to add formatting and labels

mlmcc
Salary-Structure-1-.rpt
0
 
GrapeladyAuthor Commented:
I believe this is what I am looking for, thank you so much.
0
Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

 
GrapeladyAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for Grapelady's comment #a38294194

for the following reason:

Great work!
0
 
GrapeladyAuthor Commented:
Could I reopen this question?  I just discovered there were multiple lines for employees and needed to add another grouping for employee L, F and EE# and move data into the Group 4 area.  This was impacting the count if there were multiple employee lines and don't know where to begin to change the formulas.
Salary-Structure-1-.rpt
0
 
mlmccCommented:
The new issue seems like you should ask a new question.  It is not really related to the original question

mlmcc
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now