Generate Percentage

I have a report that shows number of units in use for a given day. You can
then drill down and view the number of units in use for a given hour. I want
to display what percentage of units are in use for the given hour. Ex:
Yesterday there were 4 units in use. If you drill down you see that 1 unit
was in use @. 10AM. For 10AM, I want to display that 25% (1/4) of units were
in use.
The problem is I cannot seem to reference the SUM(UnitsInUse) value, which
is 4, that is displayed in the group header. How can I do this?
TIA
PaulPaul,
To achive this u need to pass this value as a parameter to drill down
report and use this value for your calculation in next report. As far as I
know there is now way for you to access field of other report.
Hope this helps
Thanks,
Mahesh
"Paul Timmerman" wrote:
> I have a report that shows number of units in use for a given day. You can
> then drill down and view the number of units in use for a given hour. I want
> to display what percentage of units are in use for the given hour. Ex:
> Yesterday there were 4 units in use. If you drill down you see that 1 unit
> was in use @. 10AM. For 10AM, I want to display that 25% (1/4) of units were
> in use.
> The problem is I cannot seem to reference the SUM(UnitsInUse) value, which
> is 4, that is displayed in the group header. How can I do this?
> TIA
> Paul
>