Hi there,
          I have a database with column values are amount. Crystal get the value field and calculate the % first one 100% then I need to show the percentage calculated in a chart. In order to do that I used this formula
if {@GetMonth} = 'May, 2,013.00' then
    ({@Rk6-9Col_per}) /76
else if {@GetMonth} = 'June, 2,013.00' then
    ({@Rk6-9Col_per}) /85
else if {@GetMonth} = 'July, 2,013.00' then
    ({@Rk6-9Col_per}) /97
It work well;but, I have to adjusted each month number dived each time that I added a day.
The data is grouping by months one page each months
July- 13
i.e.
date    col 9
7/1/13 100.00%
7/2/13 92.65%
7/3/13 92.63%
7/4/13 88.28%

each month is a line in the chart.
any idea will be helpful

Thanks

Rodolfo

Thanks for answer. Provably I am not doing well. Because, I got all the series line together in one at 100 the only that take form is the last month July, for instances

else if {@GetMonth} = 'June, 2,013.00' then
    ({@Rk0-1Col_per}) / count({'PPS_Oct_12_'.F3})
else if {@GetMonth} = 'July, 2,013.00' then
    ({@Rk0-1Col_per}) / count({'PPS_Oct_12_'.F3})

June goes up at 100%

Thanks

Rodolfo

Hi

I already sent the e-mail with the program attach. Did you get it?