topic Re: Sum does not sum same value in App Development

Sum does not sum same value

Erlik — Thu, 19 Oct 2023 07:04:19 GMT

Hello All,

X & Y values: 100,500,500

Function:

Sum (Aggr(Sum(distinct{<A= {'X', 'Y'}>} B), A))

sum({<A= {'X', 'Y'}>} distinct B),

Result: output of both function are: 600, however required to be 1100.

Could you please help? Thank you.

Re: Sum does not sum same value

Mark_Little — Thu, 19 Oct 2023 07:13:09 GMT

Hi can you please share it as data table with dimension names? This will allow us to formulate the set analysis.

If you are getting 600 it means one of the 500's are not include by your set expressions, But with out the data structure it would only be a guess on how and why.

Re: Sum does not sum same value

vincent_ardiet_ — Thu, 19 Oct 2023 07:49:07 GMT

If you put "distinct" 500 is counted only once, so 500+100 = 600.
And if you remove the "distinct" and the sum is above 1100, as @Mark_Little is saying, the issue is in your datastructure.

Re: Sum does not sum same value

Erlik — Thu, 19 Oct 2023 08:25:53 GMT

Mark, Vincent; Thank you so much for quick responds.

After removing distinct, sum is far above than 1100. I better start revising my data structure first.