Building a Chart on formua field

[cantademorna]

Hello there once again
I'm trying to feed a formula figure into a chart. If the formula consists of the following:

numbervar avg;

if ({@FormattedGroup} = "Pgi" and {#calls_closed_assign} > 0) then
avg := ({#avg_hours_assign} / {#calls_closed_assign})
else
avg := 1;


Then it isn't visible for feeding into a chart within the data tab within the advanced layout option; I presume because there are summary fields present. Is there any straightforward way to still feed the produced formula into a chart?

All help much welcomed

Andrew

 

[lbass]

The problem is with the running totals, I think. Are you sure you need running totals to get the correct values, or could you instead use inserted summaries?
How are the running totals set up? What is the content of your formula {@FormattedGroup}?

-LB