Calculations on totals

rbuser

I'm trying to add a calculated column to a report.
The report prints Quantity and Cost of products sold. It does not print
individual records, but totals by product. The list price is available
but not printed on the report, and is not necessarily the price that was
used. I want to display a calculated number that is calculated from the
Total Quantity and Cost displayed and also the List Price, which is not
on the report.

To simplify, lets say (Total Cost / Total Quantity / ListPrice).

Can this be done with a variable and what else do I have to set?

Thanks,
Patrick Moloney

nicocizik

Patrick,

Making the calculations in the dataset would be the easiest way to approach
this. You can do this by either creating a new column on your existing
dataset with a calculated field or createing a new dataset with the
calculated field as the only field in the dataset or configure the dataset
as a calc field lookup. Then you can display the values in a subreport by
passing them through a datapipeline as you normally would.

--