Sum Values Based on Distinct Value From Other Column

Anonymous — Tue, 26 Apr 2016 11:42:14 GMT

Hello Everyone!

So I have this tables which has a redundant data, and I would like to calculate the sum of one column without the redundancy. My table is similar to:

ID | Amount

++++++++++++++++

1 | 1000

++++++++++++++++

1 | 1000

++++++++++++++++

1 | 5000

++++++++++++++++

1 | 5000

++++++++++++++++

2 | 2000

++++++++++++++++

2 | 3000

++++++++++++++++

3 | 6000

++++++++++++++++

4 | 6000

++++++++++++++++

6 | 6000

++++++++++++++++

7 | 6000

++++++++++++++++

So my result should be

ID | Amount

++++++++++++++++

1 -------> 6000

++++++++++++++++

2 --------> 5000

++++++++++++++++

3 | 6000

++++++++++++++++

4 | 6000

++++++++++++++++

6 | 6000

++++++++++++++++

7 | 6000

++++++++++++++++

and the total should be:35000

Now I have tried the following, but still it doesn't give me the right answer (the syntax doesn't look right, to me, but since I am new to Sense I thought I should try it.):

sum(aggr(sum(DISTINCT [Amount]), ID))

Your help is appreciated.

Re: Sum Values Based on Distinct Value From Other Column

sunny_talwar — Tue, 26 Apr 2016 16:28:13 GMT

What are the values you are getting? For example for ID = 1, what is the Amount coming out to?

topic Re: Sum Values Based on Distinct Value From Other Column in App Development

Sum Values Based on Distinct Value From Other Column

Re: Sum Values Based on Distinct Value From Other Column