Hey @Alec11 I've looked at your pictures but its difficult for me to see what the problem is this way.  If you want to hop on a quick call with me you can do that here.   Would be happy to help!

Hi Jake,

I went ahead and scheduled a call for this afternoon - thanks.

Hey @Alec11 ,

In the table that sums your values, there needs to be linked records in the Deals Link field (Linked Record) for the calculation to occur.

See examples here:

Hi Zack,

I do have that link set up already:

Yes, and that looks correct! But there are no records in the field. There needs to be records in the Deals Link field within your pipeline stats for the summary to occur. Otherwise, it doesn't know what it's summing.

In the image here, it's only doing the sum on the records that are linked

Thank you Zack! that solved it.

My issue now is that i had to manually link all those deals in order to get the stats to calculate properly, but new deals are being added all the time. 

I tried to create an automation to link a new deal to that specific record, it overrides all the other linked items instead of just adding the new linked deal.

Can you think of a way around this?

You should be able to use an automation and basically do it in reverse. 

1. When new record (deal) is created
2. Update record (deal)
3. Use the record id of the stats record

You can get the record id by using a formula

That's exactly what i did, but it overrides all the other linked records with the new one, rather than just adding it

I'd look a little closer. I think you are adding the new deal record to the stat record.

You should try adding the stat record to the new deal record.

Aha, i see your point. Now it works like a charm - thanks again Zack