Solved
Percentage in Crosstab
Posted on 2004-09-28
Hi, Experts
We are using CR 8.5 and MS SQL Server 2000
I have a crosstab in the report.
It looks like this
--------------------------------------------------------------------
| | Cat1 | Cat2 |Total |
--------------------------------------------------------------------
|Group 1|SubGroup1 |Sum(FLD1)|Sum(FLD1)|Sum(FLD1)|
| | |Sum(FLD2)|Sum(FLD2)|Sum(FLD2)|
| |--------------------------------------------------------|
| |SubGroup2 |Sum(FLD1)|Sum(FLD1)|Sum(FLD1)|
| | |Sum(FLD2)|Sum(FLD2)|Sum(FLD2)|
--------------------------------------------------------------------
|Group 2| ..... and so on
FLD1 - is number of total attempts to do smth.
FLD2 - is number of fails
I need instead of those fields show the Percentage of success so if FLD1= 100 and Fld2=3 I need to Display 97%
But I can't use totals in formula in Crosstab. Is there is a way to do it?
Thanks in advance.