Grouping by formula

[sandeep2013]

I am trying to do a group by under 5% and over 5%. So created a formula {Command.total_due_amount}%Sum ({Command.total_due_amount})

This gives me a percentage of the total due for the account divided by grand total amount for everyone. I want to create a group that seperate the accounts that have over 5% and under 5 person. Crystal isnt allowing me to do this grouping, i am assuming since it is using a sum in my formula. does anyone know a work around

 

[Charliy]

Take a look at the PthPercentile and PercentOfSum functions. I've never used them, but they seem to be wht you're looking for.