doing a calculation from subtotals textboxes

Hi guys,
I'm very new to reporting services. I have a question.
I have to do a calculation based on the subtotals number. For example:
Column 1 = I have numbers and then I have a Subtotal 1, which is the
sum of these numbers
Column 2 = I have numbers and then I have a SubTotal 2, which is the
sum of these numbers
Column 3 = Column 1 / Column 2, but the SubTotal should not take the
sum of column 3. Instead, it should do SubTotal 1 / Subtotal 2.
Please let me know how to do that...I'm new to reporting services and
writing expressions.
THANKS!If I am understanding you correctly, On the subtotal line Column 3 should
simply be...
=sum(Column1.Value)/sum(Column2.Value)
"RSNewbie" wrote:
> Hi guys,
> I'm very new to reporting services. I have a question.
> I have to do a calculation based on the subtotals number. For example:
> Column 1 = I have numbers and then I have a Subtotal 1, which is the
> sum of these numbers
> Column 2 = I have numbers and then I have a SubTotal 2, which is the
> sum of these numbers
> Column 3 = Column 1 / Column 2, but the SubTotal should not take the
> sum of column 3. Instead, it should do SubTotal 1 / Subtotal 2.
> Please let me know how to do that...I'm new to reporting services and
> writing expressions.
> THANKS!
>