Charting on Formula By Group

[patryn150]

I've read the forum posts and the document at

http://support.businessobjects.com/communityCS/TechnicalPapers/cr9_charting_print_time_formulas.pdf

however, for whatever reason, I cannot figure out how to make this work. So, basic rundown:

I have report that is grouped by Day and then by Time on a half hour break down. On the half hour breakdown, I have a formula that calculates the number of phone reps that I need and returns a number. That number is what I need to have charted out in my day group footer.

The gist of the report should look like this:

-Friday
--8:30 (1.5)
--9:00 (2.6)
--9:30 (2.8)
--10:00 (3.5)
etc... to 23:00
---Graph charting how many reps I need for Friday on a 30 minute breakdown

-Saturday
Lather...rinse...repeat

Here is the code I'm using, in case anyone needs it to assist:

Required Staffing:
if {@Use Weights}="Yes" then ((({@Weighed Staffing})/(30*{@Utilization}))*(1+{@Shrinkage}))
else ((({@Average Staffing Minimum})/(30*{@Utilization}))*(1+{@Shrinkage}))

Utilization:
.85

Use Weights:
No

Shrinkage:
.20

Weighed Staffing:

if {@Use Global AHT}="Yes" then (Sum ({@Weighed Calls}, {@Time})*{@GlobalAHT})/60
else (Sum ({@Weighed Calls}, {@Time})*{@AHT})/60


Average Staffing Minimum:

if {@Use Global AHT}="Yes" then ({@Average Calls}*{@GlobalAHT})/60
else ({@Average Calls}*{@AHT})/60

Use Global AHT:
NO


Average Calls (#datecount is a running total that only calculates date changes) :

(Sum ({@Total Calls}, {@Time}))/{#DateCount}

Total Calls:

{@TotalHandledGreaterThan30}+{@TotalHandledLessThan30}

Hopefully that's a good start, and, if not, let me know what else you need.

Oh, and I'm sorry if my explanation doesn't make "too" much sense, I've been pounding at this thing for about 6 hours in every manner that I can think of and I cannot make it work at all, let alone in a manner that would be 'equitable'.

Thanks in advance!