calculating percentage of group1 vs group2

Hi,
I've got a matrix report set up that gives the following:
column Group1 Group2
Row1 x y
I need to calculate x/y and cannot get the scope straight.
Any help would be much appreciated.im having the same problem, did you find a way of solving it?
thank you very much
Eli
"devinjc" wrote:
> Hi,
> I've got a matrix report set up that gives the following:
> column Group1 Group2
> Row1 x y
> I need to calculate x/y and cannot get the scope straight.
> Any help would be much appreciated.
>|||Did you ever discover a solution? I'm trying to do the same but with no
success.
"devinjc" wrote:
> Hi,
> I've got a matrix report set up that gives the following:
> column Group1 Group2
> Row1 x y
> I need to calculate x/y and cannot get the scope straight.
> Any help would be much appreciated.
>|||me too
"devinjc" wrote:
> Hi,
> I've got a matrix report set up that gives the following:
> column Group1 Group2
> Row1 x y
> I need to calculate x/y and cannot get the scope straight.
> Any help would be much appreciated.
>|||I solved this problem by calculating the percentage in a different query and
the adding an extra matrix next to the existing one.
To deal with different levels off aggregation, I dident calculate the
percantge but the difference and the base value.
The expression for the percentage then becomes:
=iif( sum(Fields!Base.Value,"Compare") = 0, 0,
sum(Fields!Difference.Value,"Compare") /sum(Fields!Base.Value,"Compare") *100)
It's a bit heavy on the use of queries but it works and I've been looking
everywhere for a different sollution.
"Tango" wrote:
> me too
> "devinjc" wrote:
> > Hi,
> >
> > I've got a matrix report set up that gives the following:
> >
> > column Group1 Group2
> >
> > Row1 x y
> >
> > I need to calculate x/y and cannot get the scope straight.
> >
> > Any help would be much appreciated.
> >