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.