# Showing \$\$ Needed to Reach Goal

Hi! Using the Summary Block, Under Summary Type, we will be able to get the sum of the deals we have won.

However, what we want to display on the summary block is the amount needed for us to achieve the goal for the year/ month. Is it possible to display \$X - instead of just ?

Thanks!

Hmmmâ€¦ Iâ€™m actually not sure how to do that off the top of my head. Iâ€™m sure that there is probably a simple solution out there, but I canâ€™t think of one at the moment.

It sounds like you are trying to display how much money is remaining for you to reach your goal. So, for example, if your goal is \$100 and youâ€™ve achieved \$80 so far, you want the Summary Block to display â€ś\$20 left towards the goalâ€ť.

Itâ€™s almost like you want to use the Countdown Block, but you canâ€™t use the Countdown Block because it only supports dates instead of numbers.

However, what DID pop into my head was something slightly different. You could show what percentage of the way that you have reached towards your goal so far.

So, for example, if youâ€™ve achieved \$80 of your \$100 goal, you could have the Summary Block display â€ś80% of the way towards our goalâ€ť.

To do this, you would create a formula field that figures out what percentage of the way each record is towards your goal. You would predefine this â€śgoal numberâ€ť within the formula, and you would format the formula field as a percentage.

Then, within the Summary Block, you would add up all of these percentages.

So, the end result would look something like this:

Thanks for the solution! Yes that will give some perspective to the team. But I think absolute numbers will still be a better way to showcase the effort required to reach the goal.

But I will definitely implement this as a intermediate solution. Thanks again.

Youâ€™re welcome!

I actually DO know how to accomplish this by using an additional table, but I was trying to solve it for you with just a single tableâ€¦ which I donâ€™t think can be done in Airtable.

The way to accomplish this with an additional table is to simply link all of your relevant sales records from your â€śSalesâ€ť table to a SINGLE RECORD in a new table called â€śMonthly Goalsâ€ť.

So, for example, for all your sales in your â€śSalesâ€ť table that are part of your May 2020 sales goal, link all of those sales records to the exact same record in your â€śMonthly Goalsâ€ť table called â€śMay 2020â€ť.

Likewise, for June 2020, all of your sales in your â€śSalesâ€ť table that are part of your June 2020 sales goal would be linked to the same exact record in your â€śMonthly Goalsâ€ť table called â€śJune 2020â€ť.

Same thing for each month.

(Note that you will always need to manually link each one of your sales records to your monthly goals table, because there is no automatic linking in Airtable.)

The reason we need to use another table is because summary functions are only available to us when using Rollup fields or Count fields.

So, in that new â€śMonthly Goalsâ€ť table, you would create a Rollup field called â€śCurrent Sales Totalâ€ť with the formula:

`SUM(values)`

This would give you the current running total of all the sales for each monthâ€™s linked sales.

Then, still in the â€śMonthly Goalsâ€ť table, you would create a new currency field called â€śTotal Sales Goalâ€ť where you manually type in the sales goal for each month.

Then, still in the â€śMonthly Goalsâ€ť table, you would create a very simple formula field called â€śAmount Left Towards Goalâ€ť that would simply be the â€śTotal Sales Goalâ€ť minus the â€śCurrent Sales Totalâ€ť.

Then, create a new filtered view in your â€śMonthly Goalsâ€ť table that ONLY shows you the CURRENT MONTH that you are tracking. You would need to manually change this filter every month.

Create your Summary Block based on this new filtered view, and display the â€śAmount Left Towards Goalâ€ť field.

Manually type the name of the month onto your Summary Block for everyone to see, which will also give you a visual reminder to yourself to change the filter every month.

That will do the trick for you!

1 Like

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.