I have a query that's bringing in applications received, applications worked and the percentage (apps worked/apps received), grouped by month. I need to put a running percentage total into a line graph. I can't do just a running total on the percentage because the numbers come out too large.
One variable I tired (the most logical approach) takes two running totals and divides them:
NumberVar RunWorkTot := RunWorkTot + Sum({Perform.WORKED_COUNT},{Perform.MONTH});
NumberVar RunAppTot := RunAppTot + Sum({Perform.APP_COUNT},{Perform.MONTH});
Numbervar RunPctTot := (RunWorkTot / RunAppTot) * 100;
RunPctTot;
This one works when I put it into the group header or footer, but when I try to put it into the graph (with or without summarizing) I get this error:
"A print time formula that modifies variables is used in a chart or map."
I also tried the same approach by using standard running totals for apps worked and apps received by month, and then created a variable that takes the percentage of these. Again, it works in a group header or footer but I continue to get the same error as above when I try to put it in a chart.
Does anyone know of a way to get a "print time" running total formula into a graph?
IP Logged