Post Author: Elenac
CA Forum: Charts and Graphs
I am creating a chart that requires the value of a formula to appear on the x-axis. Why can i not see this formula when selecting my data for the chart. I can only see some of my formulas, not all. I went to the advance view and it does not appear there either
Post Author: Elenac
CA Forum: Charts and Graphs
The version i am using is version 11.
The report is an exisitng report with various formulas. When I try create a bar chart, i cannot see any of the formulas in the group footer section of my report. I can see the formulas in the detail section though
The report shows the grade of service for each 30 minute interval, so the formula is in a group footer
Post Author: Elenac
CA Forum: Charts and Graphs
I inserted new sections and no luck. I still cannot see the formula.
Someone mentioned to me that the formula may be a second pass formula and that is why it is not appearing on the graph. What is a second pass formula?
Post Author: V361
CA Forum: Charts and Graphs
It refers to the order that CR process formula's. You can have "Run Time", While Printing records, While reading records, etc.... So... Some formulas are processed at a later time, Say you had two groups, or a subreport, CR will "Typicaly" calculate group 1, before 2, before 3, before the sub... "Here again it all depends on where the formulas are located... and what they are doing" look in the help section for "WhilePrintingRecords"
Post Author: ljfrench
CA Forum: Charts and Graphs
I'm having a similar problem. I followed the advice here to manually create a running total field. I also created a running total for the same information using the Running Total Expert.The running total field keeps track of the average fulfillment rate for orders shipped. It is an average of one week's orders shipped on time. I need to use a manual running total because I need to calculate not only one week's average but also a four-week rolling average for charting.Both averages print fine on the report but only the running total created by the Expert is available for use on the chart. Of course, the chart is supposed to include the four-week rolling average so this situation does me no good.I've tried changing the order of formula processing but the manual RT only seems to work with WhilePrintingRecords. If only there was a way to delay chart creation until after the records were printed!Thoughts? Does anyone know a way to accomplish this task? I can provide code samples. Thank you!ljfrench
Add a comment