Forum Discussion
Revenue Count Deduplication
Hi there, I am dealing with a data calculation situation that I just can't seem to solve. We are in the business of staffing/recruitment and I need to calculate the total revenue being brought in...
Sorry about that, here are the desired outputs:
| Billings for Q1 (Jan 1 - Mar 31 2023) | |
| John | $ 5,750 |
| Sally | $ 3,000 |
| Elizabeth | $ 2,000 |
| Wayne | $ 3,000 |
| Randy | $ 3,000 |
| Phil | $ 6,750 |
| Jane | $ 1,000 |
| Joe | $ 1,000 |