In Crystal v 9, I have a report where in Group#2 (which is grouped by severity) I have 6 varibles in this group, 2 for each sveerity level (high, medium and low), the two for each severity calculate the average of two other variables (open to close, and open to first). A couple of examples of the variables in group#2 are:
1. WhilePrintingRecords;
if {Incident_History.Severity}="3. Low Impact" then numbervar firstlow/DistinctCount ({Incident_History.IncidentID}, {@Severity Name}) else 0
2. WhilePrintingRecords;
if {Incident_History.Severity}="1. High Impact" then numbervar closehigh/DistinctCount ({Incident_History.IncidentID}, {@Severity Name}) else 0
What I need to do now is copy the totals of the above varibles in to group #1 as such:
Open to first- high medium low
Open to close- high medium low
I have created more varibles. The first set are placed in group#2 and are:
EvaluateAfter ({@Avg CloseLow});
numbervar lowclose:={@Avg CloseLow}
Then I created the formula to display the value in group#1 as:
EvaluateAfter ({@Var Low Close});
numbervar lowclose
This is working only for the last group in group#2, for the other, it shows 0.00. What am I doing wrong?
1. WhilePrintingRecords;
if {Incident_History.Severity}="3. Low Impact" then numbervar firstlow/DistinctCount ({Incident_History.IncidentID}, {@Severity Name}) else 0
2. WhilePrintingRecords;
if {Incident_History.Severity}="1. High Impact" then numbervar closehigh/DistinctCount ({Incident_History.IncidentID}, {@Severity Name}) else 0
What I need to do now is copy the totals of the above varibles in to group #1 as such:
Open to first- high medium low
Open to close- high medium low
I have created more varibles. The first set are placed in group#2 and are:
EvaluateAfter ({@Avg CloseLow});
numbervar lowclose:={@Avg CloseLow}
Then I created the formula to display the value in group#1 as:
EvaluateAfter ({@Var Low Close});
numbervar lowclose
This is working only for the last group in group#2, for the other, it shows 0.00. What am I doing wrong?