Formula Tiles - Calculate a Close Ratio

How to use formula tiles in Handle CRM.

If you aren’t aware, with Handle’s Tiles you can calculate counts, averages, totals, and more. And now with Handle’s Formula Tiles, you can easily create more advanced calculations. Formula Tiles allow you to use the values of multiple Tiles for calculating complex KPIs and performance thresholds dynamically.

Whether you’re looking to understand which accounts are called too much or too little, measure your close ratio, or perform advanced inventory calculations & analysis, Formula Tiles can give you the info you need, all in one place and are a great add to your Scheduled Reports and Dashboards in Handle.

How to calculate Close Ratios with Formula Tiles in Handle

What You’ll Need

Your team needs to be marking their closed leads, opportunities, and/or quotes as either won or lost

1. Search

Start with a Search of your sales pipeline data—which probably already have.

To make the Close Ratio work across your team, make sure your Search includes Record Owner set to equal User.

If you need help building Searches for your team, just let us know. We’d be glad to help.

2. Write out your formula

Writing out the formula helps to find the variables—which will be the source tiles for the formula.

Close ratios need to divide closed and won opportunities by the total closed, which we’ll calculate as won + lost, and then multiplied by 100 to convert the decimal into a percentage.

This is the right time to pick a reporting period (we’ll do year to date) and threshold values to help the team see how they’re doing versus our expectations.

3. Make the variable Tiles

Click on the right most Tile with the large plus sign to add a new Tile and name it YTD Won
Add two Filters, one with the Edit Date set to Current Year and the other with Status equaling Won
Copy the YTD Won Tile, rename it YTD Lost, and change its Status Filter to equal Lost

Copy, Filters and other settings are found by mousing over the upper right corner of a Tile and clicking the Tile Settings icon .

You can use any other time period you want, as long as the Tiles time periods match.

4. Make a Formula Tile

Make a new Tile, and change the type from Count to Formula.

5. Enter your formula

Enter the formula:

100 * [YTD WON] / ( [YTD WON] + [YTD LOST]

Click Close when you are done.

Use standard math operators and parentheses to control the order of operation.

Typing an open bracket (“[“) gives you a list of available Tiles you can click on to add into the formula.

6. Name and Set Options

Enter a title for the Tile.
Change the number format from Number to Percentage.
Set your Goal thresholds in the Tile Options by mousing over the upper right corner and clicking the Tile Settings icon .
Convert the display to the Gauge setting by clicking on the dot that appears under the title on mouse over.