Charting formula using " previous(table.field) "

[theDeej]

Seagate Info 7.5
Crystal Reports 8.0

I have created a formula field that calculates a growth rate from month to month as follows:

({Statistics.EnrolledUsers} - previous({Statistics.EnrolledUsers})) % previous({Statistics.EnrolledUsers})

Since I'm using the "previous" function, the first record does not have a growth rate value. This is fine, but when I chart the growth rate (line chart), it displays the first record's date, but no value (because there isn't one). Is there a way to get rid of that month column on the chart? Is there a way to tell the chart to ignore the first record?

For the chart, the group axis is the date (month and year) and the data axis is the growth rate value (percentage).

Thanks in advance!

~D

 

[synapsevampire]

Perhaps you can fabricate one within a formula based onfirstrecord?

I don't think that you can eliminate it from the chart, though you can use a bottom N, so if you have a static number of rows, you can approach it that way.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[theDeej]

Thanks for replying. I tried to use topN, bottomN, but they don't work. The top/bottom applies to the summary value (growth rate) so I end up getting the largest or smallest growth rates - rather than the most recent months.

Any other ideas are appreciated!

Thanks again!

-D