I am trying to put a calculated column in my report - which is simple one value column as a % of another value column. I either get one % figure which equates to the highest level of aggregation (and hence is not true when you drill down and it still shows the same %), or I get error. Is there something I am missing - I am trying everything!

can you please share your calculation with us, you might want to try expression, in 3 rd column which will be like ColumnX * 0.01 Gaurav Gupta http://sqlservermsbiblog.blogspot.com/

Hi, Do you mean you defined a calculated field in the dataset by the expression like =0.1*Fields!Fieldname? If so, we can use this field in the report as well as use the original query fields. If I have misunderstood, please point out. Since the calculated field doesn’t work as expected in the report, could you please post an example to elaborate the report structure, the expected result and the current result. Then I will provide you further assistance. Thanks, Tony Chain Please remember to mark the replies as answers if they help and unmark them if they provide no help