Sum Total (Value 1 + Value 2) returning different results to Sum Total (Value 1) + Sum Total (Value2)

[#1]

Hi All,

I have checked a scenario in set analysis expressions that Sum Total (Value 1 + Value 2) function is returning different value to sum total (VAlue1) + Sum total (Value2). Seems to be the second expression is returning correct value where as the first one isn't?

Can any one experienced this issue earlier? Is there any workaround to this issue or should have to live with using the latter set expression always?

Thanks, Srikanth

[jonathandienst · Accepted solution]

You probably have some null values in Value1 and/or Value2. The result of these additons will always be NULL, regardless of the other value, so your first total is missing the values with null "partners". The second expression does not have this problem.

[jonathandienst]

There is no workaround needed. This behaviour is correct and by design and consistent with the null handling in other systems. You can also use:

     Sum(TOTAL Alt(value1, 0) + Alt(Value2, 0))

     or

     Sum(TOTAL RangeSum(Value1, Value2))

[#4]

Thanks, that could be the issue. Have converted to number formats and tested both the expressions and they work perfectly.

Thanks, Srikanth