How to Reference Group Data

[shelby55]

Hello

I am using Crystal 9.0 from data in an Access 2003 database.

I have a report where I have grouped on fiscal year. I have various metrics per fiscal year like volumes of cases, volumes of acute days, volumes of total days. What I want to do is create a formula that compares the values in the various years to come up with a formula that narrative to place in the footer. For instance, be able to indicate % increase/decrease between certain years.

However, it doesn't seem that I can reference the group values. For instance, each group has a number which we can use to suppress but I can't indicate "if groupnumber = 2 then sum(acutedays)*100/sum(total days)" or anything like that.

How do I get it so I can reference these values? Thanks.

 

[IdoMillet]

Create separate conditional totals for each year.
One approach is to create a formula such as
IF Year = x Then Value else 0. Then, sum that formula.

hth,
- Ido

view, export, burst, email, and schedule Crystal Reports.

http://www.MilletSoftware.com