I'm really desperate for some help, the results of my query make no sense at all!
I am adding a 1 to a simple SUM base measure and then doing a SUMX over ALL values in a column.
So I have [Sum Users]. I add 1 to this in [Sum users plus 1]. Then for both measures I do a SUMX over ALL values in 'Dates' (which is actually ga_customVarValue4). But [Sum Users plus 1 over All Dates] returns incorrect results and for the life of me I can't understand why. The sum of values in [Sum Users] should equal [Sum Users plus 1 over All Dates] but it doesn't.
It's definitely to do with the +1. If I replace this in the formula with a multiplier (say *2) then the results are correct.
Any ideas? I'm really at my wits end here!
I am adding a 1 to a simple SUM base measure and then doing a SUMX over ALL values in a column.
So I have [Sum Users]. I add 1 to this in [Sum users plus 1]. Then for both measures I do a SUMX over ALL values in 'Dates' (which is actually ga_customVarValue4). But [Sum Users plus 1 over All Dates] returns incorrect results and for the life of me I can't understand why. The sum of values in [Sum Users] should equal [Sum Users plus 1 over All Dates] but it doesn't.
It's definitely to do with the +1. If I replace this in the formula with a multiplier (say *2) then the results are correct.
Any ideas? I'm really at my wits end here!
