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...
Anonymous
Can you provide the desired output with regards to the sample data you have provided?
Thanks,
Naveen
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 |