formula in Bar graph not coming

[Former Member]

Hi

I am not able to show formula in graph as it is not coming in the Available Field List of chart expert.

My req is like, I have the No of TTs and the TTR value for each TT.

According to my req. I have created 2 running total fields Sum of TTRs and Count of TTs.

In graph I have to show the Sum of TTRs / No of TTs. For this I have created the formula. My values are coming fine in report. But this formula I am not getting in chart.

Pls let me know why this is not coming in chart expert.

Pls help.

Thanks

Sunny

[Former Member]

Hi Hi Sourashree,

I have placed the formula in the Group Footer. Thats why I am getting the correct value but I am not able to see that formula in the graph.

I am sending you the code written in formula.

StringVar ActualMTTRvalue;

StringVar array SplittedMTTRValue;

StringVar MTTRHrs;

StringVar MTTRMins;

NumberVar MTTR := {#SA Sum of TTR for MTTR}/{#SA Count of TTs for MTTR};

ActualMTTRvalue := toText(MTTR/60);

SplittedMTTRValue := split(ActualMTTRvalue,".");

MTTRHrs := SplittedMTTRValue[1];

MTTRMins := toText(MTTR mod 60);

SplittedMTTRValue := split(MTTRMins,".");

if SplittedMTTRValue[1] <> "0" then

MTTRMins := MTTRHrs + " : " + SplittedMTTRValue[1] + " Min"

else

MTTRHrs := MTTRHrs + " Hrs"

Pls help.

Thanks,

Sunny

[Former Member]

Hi Sourashree,

Thanks for your support.

But my problem is not for the running total fields. It is coming in the graph.

Actually I have created to Running Total fileds, one gives the count of TTs and another gives the Sum of TTR.

Now, I have created formula which calculate Sum/Count. This gives me the exact value which I need to populate in graph. But my problem is I am not getting this formula in the field list.

Is there any way to display the formula this in the graph?

Pls suggest..

Thanks

Sunny

[Former Member]

Hi Sunny

Place the formula field on to the report and then try inserting the chart. You should get the formula field in the available fields list of the chart.

Hope this helps!!!

Regards

Sourashree

[Former Member]

Hi Sunny

Drag the running total fields on to the report and then see if you get the running total fields in available fields of the chart.

If you have groups in your report, place the running total fields on to the group footer. Insert a subsection for the group footer and insert the chart on this.

You should be able to get the running total fields in the available fields list of the chart now.

Hope this helps!!!

Regards

Sourashree