Formula grouping?

[timbaktuu]

Hello Gurus, I need your advice. following crystal report need to have one 2 extra groupings. here is the structure.

agent> Grouping by day>detail section(all details)

Raul Smith
Monday--> need to divide in new signup/old account ???
TUe
Wed


Now i need to make the records sort as Call related to new account or old account
I am confused with the grouping, these are the formulas i created.

@new IF "New" in {Field} then 1 else 0

@ NewCount = If @new=1 then sum(@new)else count(@New)

how do I do place the grouping now under weekday, grouping hierarchy is Agent name> Day>----here need to insert group for old and new---- suppressed details section.
AM i doing it right? and how do i proceed ahead. thanks.

 

[timbaktuu]

or the formula would be like this ??

@NewCount = If @new=1 then sum(@new)
@oldcount=If @new=0 then Count(@New)

 

[Madawc]

Crystal won't let you group using a formula that refers to more than one detail line.

I'm not clear what you're trying to do with your formulas. But there is no sense in counting @new, you might as well count {Field}. And since @new is either 0 or 1, you don't need to test before summing it.

The use of Crystal's automated totals is outlined at FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP