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.