Hi,
I hope someone on here can help me, I've been trying to find out how to do this for ages but to no avail!
I have a cross-tab table as follows
{Person}{AuditSurvey.SvName1}|{AuditSurveyAnswer.SvScore}|{Avg of AuditSurveyAnswer.Score (Number)}
And so on. At the end of the report I need to count all the rows which have an average of >=4. This is done via a running total, summarising {Job} and using a distinct count and evaluating using the formula
Average ({AuditSurveyAnswer.SvScore}, {AuditSurvey.SvName1})>=4
The problem seems to be that it is rounding up. The {Avg of AuditSurveyAnswer.Score (Number)} scores are formatted to 2dp of the 15, all are >= 4 with two exceptions, which are 2.88 and 3.88. The formula I have gives me a count of 14 as being >= 4, I think this is caused by CR rounding up, as when I change the data to be <3.5 it appears to count it correctly.
I am using CR 2008.
Many thanks.
IP Logged
