Hi all,
Can I ask you how I can create zero in Amount Due for the same Customer ID?
Customer ID | Amount Due | Amount | Order Date | Order ID | Product Type | Price |
1 | 515.98 | 800 | 09/05/2023 | 7659258 | A | 271.3240741 |
1 | 515.98 | 800 | 27/04/2023 | 7659256 | A | 672.1111111 |
1 | 515.98 | 800 | 10/05/2023 | 7659259 | B | 761.6018519 |
1 | 515.98 | 800 | 05/05/2023 | 7659257 | C | 271.3240741 |
2 | 43690.47 | 50000 | 15/01/2023 | 7659255 | C | 976.037037 |
2 | 43690.47 | 50000 | 14/12/2022 | 7659253 | A | 179.212963 |
2 | 43690.47 | 50000 | 13/01/2023 | 7659251 | C | 193.2592593 |
But I would like to have:
Customer ID | Amount Due | Amount | Order Date | Order ID | Product Type | Price |
1 | 515.98 | 800 | 09/05/2023 | 7659258 | A | 271.3240741 |
1 | 0 | 0 | 27/04/2023 | 7659256 | A | 672.1111111 |
1 | 0 | 0 | 10/05/2023 | 7659259 | B | 761.6018519 |
1 | 0 | 0 | 05/05/2023 | 7659257 | C | 271.3240741 |
2 | 43690.47 | 50000 | 15/01/2023 | 7659255 | C | 976.037037 |
2 | 0 | 0 | 14/12/2022 | 7659253 | A | 179.212963 |
2 | 0 | 0 | 13/01/2023 | 7659251 | C | 193.2592593 |
so all values which are duplicates should be 0.
I Will be grateful for support!