Crystal 2008: Line Chart of Running Totals Pitches up and down

[mendezcp]

Hi All,
Newbie here. I am working on creating a line chart that uses running totals by day of month in order to compare this months progress to prior months. The chart looks good except running totals do not escalate. They pitch up and down.

To do this I did the following:
- created a running total formula {RTotal0} that appears to be working fine.

- then I used a formula that extracts the day of the month {@Day_of_month}from a ship date field. Also appears to work fine.

-Applied a line chart using the following criteria.
-Change on {ShipDate} Grouped by month. 1st Priority
-Change on {@Day_of_Month} 2nd Priority
-Show Values on #RTotal0

The line chart looks fine except that the running totals are off. Instead of constantly increasing throughout the month, they spike up and down. Again running the running total in my details section works fine. I did set running totals to reset upon each group change ( grouped by ship date, breaking every month).

Any help is greatly appreciated.

 

[lbass]

In the chart expert, after adding shipdate and while it is highlighted, click on "Order" and select on change of month.

-LB

 

[mendezcp]

Thanks Ibass,
I did that and it still isn't working.

 

[lbass]

I tested this here, and it worked properly, so please explain the exact set up of the running total.

-LB

 

[mendezcp]

Sure thing.
Running RTotal0 Criteria
Field to summarize: {@GA_Shipped}
Evaluate: For Each Record
Reset: On change of Group {Group #1: oe_pick_ticket_ship_date}

 

[mendezcp]

Got It!!
It turns out that the detail was not in order by the day of the month. This was because the group sort was specified to end after each month, and sort in ascending order. I took this to mean that it would also sort to individual lines in ascending order. Not the case. I added a sort criteria that allowed it to sort then by day of the month. This solved everything. Thanks LBass, letting me know that it was working allowed me to go back to the basics.