Hey all, I was hoping someone would be able to help me on something that I cannot seem to get right. Let me show you an example of what I am trying to do. 

Here is an example of the structure of my data, note the multiple records for a single company. 

Opportunity Name	Net New ARR
Company 1	$50,000
Company 1	$50,000
Company 2	$150,00
Company 2	$150,000

With the data like this it will just sum the data for me so that Company 1 will shows a net new arr of 100k and company 2 would show $300k ARR. That isn't the correct value. How can I get it to group the company so that it only shows the distinct total for Company 1 being $50k and company 2 being $150k? 

Any thought on how I could build this formula would be super appreciated!