How do I add a row to the output table? What information can I include in a new row?
New rows in the output table can be used to display two different types of Metrics:
Calculations can be used to write custom expressions based on the results of your model. For example, Profit Margin using Revenue and Net Income events from your model like so:
Measurements allow you to copy an event from your model and display the results in a different format. For example, in addition to a row that displays your Checking Account ending balance each period, you can add a row that also displays the net change in the balance per period like so:
Learn more about the different display options available for output table results here.
How do I write an expression for my calculation?
Calculations are an easy way to display custom metrics associated with your Summit model in the output table. Calculations run "separately" from the model itself. Said another way, they are a helpful tool for analyzing the performance of, rather than actors in, your business.
Calculations are derived from custom expressions you can write in the Metrics Editor. Unlike events on the canvas which use SEL (Summit Event Language) to dictate their behavior, custom expressions use SQL (Structured Query Language) to return results.
SQL is a standard language used to update databases and is written with familiar mathematical operations. The available operations in Summit are:
abs(x)➡️ Returns the absolute value of x
iif(x, y, z)➡️ If x is true, return y, if not, return z
ceil(x)➡️ Returns the next integer value above x
floor(x)➡️ Returns the next lower integer value less than x
max(x, y, ...z)➡️ Returns highest value of values passed
min(x, y, ...z)➡️ Returns lowest value of values passed
round(x)➡️ Round x to the next whole number
Round to a specific number of digits:
round(x, y)➡️ Round x to y digits to the right of the decimal point
pi()➡️ Returns the number pi
random()➡️ Returns a random number
power(x, y)➡️ x raised to the y-th power
square(x)➡️ Returns x squared
sqrt(x)➡️ Returns the square root of x
ln(x)➡️ Natural logarithm of x
log10(x)➡️ Base-10 logarithm of x
exp(x)➡️ Returns e (the base of the natural logarithm) to the power of x
sign(x)➡️ Returns -1 if x is negative, 0 if x is zero, and 1 if x is positive
🔔 Note: You do not need to include
= for calculations written in the Metrics Editor.
Can I reference a prior or future period within the same row? For example, can I calculate the difference between this month's and last month's results?
Yes! You can use the SQL functions
lag() to reference the value in the previous period and you can use
lead() to reference a value in the next, future period.
So, using the described example, subtracting the
lag() value from the current value will then display the difference between the two periods. Change in MRR per period (e.g.
MRR Growth in raw dollars) could then be written as
mrr - lag(mrr) and the growth rate could be calculated as
mrr growth / lag(mrr).
What are some common metrics used on Summit models?
The calculations you write will depend on the purpose of your model, but since forecasting business financial performance is a common reason people start to use Summit, we've listed some of the metrics most often associated with those models below for inspiration:
Compare Results: Value 1 (e.g. Actuals) - Value 2 (e.g. Forecast)
You can compare the difference between any two results with simple subtraction. If you're comparing a positive and negative value, but don't want to consider the sign, wrap the event name in an absolute value operator
Growth Rates: (New Value - Original Value) / Original Value OR 1-((Original Value - Change in Value) / Original Value)
The percentage change in a value like Revenue, Expenses, Bank Balance, etc. between two time periods.
Quick Ratio: (New MRR + Expansion MRR + Reactivation MRR) / (Contraction MRR + Churned MRR)
The quick ratio helps you understand the health of your revenue growth, given customer churn. A higher quick ratio indicates strong growth performance.
Net Churn Rate: (Churn Revenue - Expansion Revenue) / Total Revenue
Net churn rate can tell you whether revenue increases from existing accounts outpaces churn. A negative value means expansion is overtaking churn and can indicate strong retention and overall customer health.
Average Revenue Per User (ARPU): Total Revenue / Total Customer Count
The average value of a customer. The higher your ARPU, the better!
Customer Lifetime Value (CLTV): ARPU / Churn Rate
An estimate of the total revenue you can expect to receive over the life of a customer. This provides a helpful target for your customer acquisition and support costs (i.e. you should make sure the costs of CAC and support is less than CLTV!).
Customer Acquisition Cost (CAC): Total Sales & Marketing Expenses / Number of New Customers
The amount of sales and marketing dollars spent in a given period to convert new customers. This is a helpful metric to determine whether you can grow your business in a cost-efficient manner.
Gross Margin: Revenue - Cost of Goods Sold (COGS)
Gross margin is the gross profit retained after incurring the direct costs associated with producing the goods and services being sold. This is profit before deducting general and administrative costs.
Gross Margin Ratio: (Revenue - COGS) / Revenue
This is Gross Margin in percentage terms and is helpful for comparing a business against its competitors or raising attention to temporary production costs spikes or even broader cost management challenges.
Profit Margin: Net Income (i.e. Profit) / Revenue
Profit margin compares profit to sales and can indicate how well the company is handling all finances including operational expenses.
Why are some values listed as "Unavailable" in the Metrics Editor?
The unavailable values are metrics that were created using a combination of an event value and a custom metric. These cannot be used in new metrics because they create a technical conflict that would prevent the system from generating results in the output table, similar to a circular reference in other spreadsheet software.
Keep Reading: Charts