Line graph 1

[miketbuck]

I am trying to create a line graph that follows the productivity of a group of practitioners, every two weeks, over a specified timeline. My report has grouping by program, year, and two week periods. I have a formula that looks at the productivity percent within that 2 week period. I would like a report that takes that percent and graphs it over what ever period specified as a report parameter. I would like my report to use the two week "End date" as the "On Change of" value and the "Show Value" should be the Productivity Percent. Problem is you can not use a formula as a data field. Is there a way to get a formula value as a graph parameter?

 

[miketbuck]

I want to be clear that the formulas that the system will not accept are any formula that has an equation included. The equations generally include one or more running totals. I have tried to force the system to read them at different intervals (ie..whilereadingrecords, whileprintingrecords) to no avail.

 

[lbass]

You need to show the actual content of the formulas you are trying to use (and of any nested formulas).

-LB

 

[miketbuck]

My Productivity Percent formula is
if {@Total Hours}= 0 then 0 else
{@Total Calculation}/({@Total Hours}*.625)*100
Total Calculation formula is
{@HOURS}+ {#RTotal1}
Hours formula is
IF IsNull ({#RTotal0}) THEN 0 ELSE {#RTotal0}/60
Total Hours Formula is
{@Base Hours} - {@Leave}
Base Hours is
IF IsNull ({#RTotal4})THEN 0 ELSE {#RTotal4}/60
Leave is
If IsNull ({#RTotal3})then 0 else {#RTotal3}/60
An example of a running total would be #RTotal0 -
Summarize - @Duration to Number
Type - Sum
Evaluate - Formula
not (({staff_tx_history_2004.SERVICE_CODE}) in
["ANNL","SICK","ADMIN","HLDY","DELETE","FURLOUGH","ANBBST","ANBBSTG","ANBPSR","AR001","AR002","AR003","AR004",
"AR005","AR006","AR007","AR008","AR009","AR010","AR011","AR012","AR130","AR131","AR132",
"AR133","AR134","AR150","AR200","AR201","AR202","AR203","AR204","AR400","AR401","AR402","AR403",
"AR404","AR405","AR406","AR407","AR501","AR502","AR503","AR504","AR505","AR506","AR507",
"AR508","AR1000","BREAK","AR140","NR141","SR143","SR142"])
and {@Actual Combined}=1
Reset on Change of Group#3 (End Date)

 

[lbass]

I don't think you will be able to chart on these formulas that use running totals. I am dizzy from the array of nested formulas, which are a pet peeve of mine. I can't even tell whether you could convert the running totals to conditional formulas, because I don't know the content of all the nested formulas.

You could try converting the rts, by using formulas like this:

if not (({staff_tx_history_2004.SERVICE_CODE}) in ["ANNL","SICK","ADMIN","HLDY","DELETE","FURLOUGH","ANBBST","ANBBSTG","ANBPSR","AR001","AR002","AR003","AR004","AR005","AR006","AR007","AR008","AR009","AR010","AR011","AR012","AR130","AR131","AR132","AR133","AR134","AR150","AR200","AR201","AR202","AR203","AR204","AR400","AR401","AR402","AR403","AR404","AR405","AR406","AR407","AR501","AR502","AR503","AR504","AR505","AR506","AR507","AR508","AR1000","BREAK","AR140","NR141","SR143","SR142"])and
{@Actual Combined}=1 then
{table.duration}

Then use these in summary formulas. Still not sure you will be able to chart on them though.

-LB

 

[miketbuck]

I had tried originally to limit the use of rts but was not successful. Within this report I have 26 formulas, 14 rt's, 5 groupings, and three sub reports. I tried rewriting the rts as summary formulas with no success. I going to try to write a sub report that looks at only one staff member and only their productivity and insert it under that individuals grouping. Since this runs for all staff and all services for a year, its slow already, this won't help that problem at all.
I use nested formulas when I have multiple uses for a variable. This limits the amount of time duplicating information.