I am trying to sum a series of numbers and divide the total by the total sum of a different series of numbers. The expression I'm using is giving me an incorrect total.
S, Nothing's wrong about the expression itself. Given the set conditions are the same, it is sum([Total_proceeds])/sum(Market_Value). It returns a mesure in %. Now, what is your definition of this expression total? It depends on your object properties. Is it sum of rows, or avg of rows, or expression total, or anything else? I assume you only need to use the correct total mode - which I cannot guess for you.
Michael, thanks for the response. Would you mind if I post a simplified example that you could look at. I've tried different 'of rows' properties such as average and sum. tx, S
I'm just curious as to whether you were able to figure out where I was going wrong after looking at the sample? It's such a stupid problem but it's been holding me up for a while now.
Actually your current expression is calculating correctly. If you take out the two dimensions seperately and make a simple sum after you have chosen the same criteria as in your formula the sum calculates to
R 279495909,75
and
R 601890761,43
which then gives
0,464363183
I think you might have taken out the rows in Excel and summed them but the "Excel number" is not correct as rows are doubled. See enclosed.
