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.