Hi, I have built a report and I have two seperate tables. Each table has a value for the sum. Is there a way that I can use these figures to do a custom calculation? So table one is x and table two is y Then Sum (x * y) / sum (x) Thanks, Conor

Ok. If I can put the two values into one table, can I use an expression as per my formula above??Thanks, Conor

If I understand right, you have two datasets, which have two different totals and you want to use them in calculation. Its possible. While doing custom calculation, under expression, select "dataset " from the left most column at the bottom. From the middle column, select the dataset and the from the right column, select the field that has sum function defined on it. This calculation should not be in any of the above tables and again, it should be converted to integer if its a string.

Thanks for that Kiranmayee. That work greatThanks, Conor

Sorry I have another question relating to this. My DB is storing values for x and y every 5 seconds. I need to calculate x * y =z and then get the sum of this for the day, and then divide the daily value z by the sum of y.Thanks, Conor