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
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