Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I try to use sum(amount) but it's not working please advice .
current table :
ACCOUNT_NUM | Amount |
10000586600 | 1430 |
10000639420 | 660 |
10000639420 | 1320 |
10000719600 | 1117 |
10000720990 | 1500 |
10000720990 | 3300 |
10000724620 | 2300 |
10000724670 | 486 |
the expected table is :
ACCOUNT_NUM | Amount |
10000586600 | 1430 |
10000639420 | 1980 |
10000719600 | 1117 |
10000720990 | 4800 |
10000724620 | 2300 |
10000724670 | 486 |
What, exactly, is "not working"? Sum(Amount) looks like it is the correct formula here.