Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Groups in Crystal

Status
Not open for further replies.

slickp

Technical User
Feb 15, 2006
35
GB
Is there any way around grouping a fomula which has a sum in it?

It has never worked for me and its annoying cause i've got got a report at the moment which needs grouping by this formula.

Basically i've created a formula for Net Commission and then summed it in a group. Then i've created a fomula using this sum field so i can put the Net Commission into bands i.e

if Sum ({@Net Commision}, {CLIENT.ClientNo}) < 500 then "<£500" etc, etc.

I now want to group by this formula and it won't let me.

Any ideas
 
Please share the content of {@Net Commission}.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top