🎓
Models University
  • Alpha Testing
    • 👋Welcome to Alpha
    • Installation and Setup
    • Support and Help
    • Terms and Licence
  • Start Here
    • What is Models?
    • Quick start
    • Tutorials
  • Using Taglo Software
    • The Taglo Interface
      • Navigating in Models
      • List Views
      • Adding Items
      • Deleting Items
      • Searching and Filtering
      • Previewing and Editing
      • Using Wizards
      • Save/Undo/Redo
      • Keyboard Shortcuts
    • Data Storage
    • Namespaces
    • Inbuilt data
  • Tags
    • Introduction to Tags
    • Tag Basics
    • Tags Applet
    • Advanced Tags
  • Models
    • Home Tab
      • Creating a Model
        • Timings
      • Version History
      • Application Settings
    • Model Editor
  • Variables
    • Variable Basics
      • Variable Setup
      • Unit and Calculations
    • Time Segments
      • Time Segment Setup
    • Summaries
    • Default Assumptions
  • Units
    • Introduction to Units
    • Key Unit Concepts
    • Advanced Units
    • Defining a Unit
    • Unit Factors
  • Dimensions
    • Introduction to Dimensions
    • Dimension Setup
    • Defining Unit Variance by Dimension
  • Data Types
    • Data Types
  • Assumptions
    • Introduction to Assumptions
    • Creating/Referencing Assumptions
    • Assumptions Wizard
      • Assumption Dates Step
      • Assumption Values Step
      • Linking to external Data
      • Linking to Excel Inserts
      • Sensitivity Values
  • Calculations
    • Introduction to Calculations
    • The Calculation Page
      • The Formula Entry Bar
      • Unit Analysis
    • Calculation Parts
      • Variable References
        • Referencing Time
        • Referencing Dimensions
        • Lookups
        • Summarising Variables
      • Period References
      • Functions
        • Advanced Functions
  • Aggregation
    • Introduction to Aggregation
    • Creating Aggregations
  • Rearranging
    • Introduction to Rearranging
    • Rearranging Example
    • Rearranging Tips
  • Cases
    • Introduction to Cases
    • Managing Scenarios
    • Managing Sensitivities
  • Layout
    • Generating Excel
    • Auto Layout
    • Sheets
      • Sheet Content
      • Adding and Editing Content
    • Excel Formatting
      • Excel Themes and Styles
      • Line Formatting
    • Data Tables
    • Excel Generation Troubleshooting
  • Excel Inserts and Outputs
    • Excel Inserts
    • Excel Outputs
  • Number Formats
    • Number Formats
  • Dashboards
    • Dashboards Basics
    • Dashboard Layout
    • Dashboard Items
    • Excel Dashboards
  • Metrics
    • Metrics
  • Charts
    • Introduction to Charts
    • Chart Customisation
  • Importing Models
    • Importing Models
  • Data
    • Introduction to Data
    • Creating Data
    • Data Sources
Powered by GitBook
On this page
  • Overview
  • Autocomplete Dropdown
  • Full list of Autocomplete option types
  • Referencing a new Variable
  • Entering Text
  • Entering Numbers
  1. Calculations
  2. The Calculation Page

The Formula Entry Bar

How to create Calculations in the Formula Entry Bar

PreviousThe Calculation PageNextUnit Analysis

Last updated 8 months ago

Overview

The Formula Entry Bar in the Calculations step of the dialog is the fastest way to create Calculations, by typing in a formula, similarly to how you would in Excel.

Autocomplete Dropdown

On typing any text in the Formula Entry Bar, an autocomplete dropdown will appear, as in the examples below:

Dropdown example
Details

Typed in "Peri" Brings up options for:

Typed in "Month" Brings up options for:

Autocomplete options can be selected in any one of three ways:

  1. Press Tab to select the first option in the list

  2. Click on an option with the Mouse

  3. Press Down (arrow key) to navigate through the list, and then press Enter to select an item

Full list of Autocomplete option types

Symbol
Type
Details

Variable Reference

Reference to New Variable

Opens a wizard to create a new Variable; Adds a reference to the new Variable once created

Period Reference

Function

Lambda function

New Lambda function

Opens a wizard to create a new LAMBDA function, and then creates a reference to it

New Argument

Argument Reference

Applies to LET and LAMBDA functions. References a previously defined argument.

Referencing a new Variable

This means you can stay within your current train of thought at all times.

To do so, follow these steps:

  1. Start typing a name for your new Variable in the Formula Entry Bar

  2. A new dialog will open - edit your new Variable here

  3. Click Finish in the new dialog - a reference to your new Variable will be created in the formula

Entering Text

Entering Numbers

To enter numbers, type the number directly into the Formula Bar. Any numbers typed in will automatically be interpreted as a number.

Generally, it is not advisable to hardcode numbers into Calculations. Try to create Variables for these numbers instead.

There are exceptions to this rule such as the hardcoded 1 in inflation formulas like Cost = Cost[-1] * (1 + Inflation)

Adding

Adding reference to an (Months per period)

Adding a reference to a named Peri

Adding a new function named Peri()

Adding a reference to two existing Variables

Adding a reference to a new Variable named Month

Adding a (either EOMONTH or MONTH)

Adding a new Lambda function named Month()

Creates a to an existing Variable

Creates a of the Model (a date value)

Adds a (supported) name and opening bracket

Adds a reference to an existing function

Applies to and functions. Creates a new argument which can be referenced in subsequent sections of the function.

The allows you to create and reference a new Variable from within another Variable's calculation, without having to leave the Variable that you are currently editing.

Select the new Variable () autocomplete item in the dropdown

To enter text strings, type your text into the Formula Bar using a " character (double quotes) to indicate the start and end of the string. When you enter the second ", a Text will be created.

If you have a Variable name which starts as a number, this means you may not find it easy to add from the autocomplete dropdown, in which case you can use the Add Variable Reference button which can be found at the end of the list of Calculation Parts.

Taglo interface
Calculation Part
reference to a Period
Function
Variable
reference to current Period
existing Variable
Function
new Variable
LAMBDA
LET
LAMBDA
Lambda
GIF showing a user entering a calculation into the Formula Entry bar. As the user types, a dropdown appears with the names of Variables and other items to choose from.
Formula Entry Bar example
reference