Variables & Formulas

How use your workbook section of Finmark to create variables, formulas, and view system generated variables.

20 articles in this collection
Written by Keith Gruver, Annika Walima, and Avery Miller

Custom Variables & System Variables

What are System Variables?

In this article, we describe what System Variables are and how to use them in a formula for driving a forecast.

Written by Keith Gruver
Updated over a week ago

System Variables for Integrated Accounting Platforms

Finmark offers automatically generated System Variables from your Accounting Integration. Learn more in this article.

Written by Annika Walima
Updated over a week ago

What are Custom Variables?

In this article, we will explain what Custom Variables are and how to use them to build customized forecasts for expenses and revenue

Written by Keith Gruver
Updated over a week ago

Tracing Dependencies in Fx Variables

Learn how to find every location a variable is being used within your model.

Written by Avery Miller
Updated over a week ago

Building formulas

Tracing Co-Dependencies on Custom Variables

In this article, we will walk you through how to trace linked variables.

Written by Annika Walima
Updated over a week ago

How to build a formula in Finmark

In this guide, we will walk you through how to build a formula using variables, offsets, and operators

Written by Keith Gruver
Updated over a week ago

Using Formulas to Forecast Revenue

In this article, we guide you on how to use formulas in Finmark to build a revenue forecast

Written by Keith Gruver
Updated over a week ago

Using Offsets in Finmark

Learn how to use Offsets in Finmark

Written by Avery Miller
Updated over a week ago

Popular Use Cases

Success Formula - Forecast Revenue with a fluctuating growth rate

In this article, we will guide you through modeling a growth rate that changes over time for your revenue forecast

Written by Keith Gruver
Updated over a week ago

Using Formula Functions in Finmark

Using "Mod" Formula Function

Written by Keith Gruver
Updated over a week ago

Using "IntegerPart" Formula Function

Written by Keith Gruver
Updated over a week ago

Using "Power" Formula Function

Written by Keith Gruver
Updated over a week ago

Using "Or" Formula Function

Written by Keith Gruver
Updated over a week ago

Using "Nor" Formula Function

Written by Keith Gruver
Updated over a week ago

Using "Min" Formula Function

Written by Keith Gruver
Updated over a week ago

Using "Max" Formula Function

Written by Keith Gruver
Updated over a week ago

Using "Ceiling" Formula Function

Written by Keith Gruver
Updated over a week ago

Using "Round" Formula Function

Written by Keith Gruver
Updated over a week ago

Using "IF" Formula Function

Written by Keith Gruver
Updated over a week ago

Using "Count" Formula Function

Written by Keith Gruver
Updated over a week ago