EIGENN.
docsguidesapichangelogpricingsign in
EIGENN.

Troubleshoot formulas

Find a formula error, read the message, and correct unknown names, loops, wrong periods, and wrong totals.

Eigenn checks a formula before it saves it, and again when it calculates the model. Use this page to find the cause of an error message or of a value that looks wrong. The messages on this page are the exact text that Eigenn shows.

Find the error

  • In the formula bar, the message shows below the field. Enter does not save until you correct it.
  • In the grid, a cell that cannot calculate shows Error. The Formula column shows a warning icon. Point to the cell or the icon to read the message.

Unknown names

MessageCause and correction
No variable or function called "Revnue".The name does not match a variable. Correct the spelling, or select the name from the suggestions
No variable or function called "roud". Did you mean `round`?The name is close to a function name. Use the suggested name
Call sum with parentheses, for example sum(...).A function name has no parentheses. Add the arguments, such as sum(Revenue[all])
Unexpected "1"The variable name starts with a helper name, such as Year 1 revenue. Rename the variable

Syntax errors

MessageCause and correction
Expected "else"An if has no else part. Add else and a result
Expected a closing parenthesisA ( has no ). Add the missing parenthesis
The formula ends unexpectedlyThe formula ends after an operator or a keyword. Complete the expression
Unexpected ","A number has a thousands separator, such as 1,500. Remove the comma
Unrecognized input at ".5 * 2"A character is not valid in that place. Write 0.5, not .5
round(number, [decimal_places]) takes 1–2 arguments, not 3The function has too many or too few arguments. Read its signature
Fill in {rate} — Tab moves to the nextA placeholder from a template or a function is still in the formula. Replace it. Enter does not save until you replace all placeholders
Add a formula before saving.The formula is empty

Circular references

MessageCause and correction
A formula cannot reference itself.The variable reads itself in the same period, such as Profit[this]. Use Profit[previous]
This would create a loop: Gross profit → Net income.Two or more formulas read each other in the same period. Change one formula to read the previous period, or move part of the calculation to an input
This would create a temporal loop: A[t] → B[t-1] → A[t].Formulas read each other across periods, and the offsets cancel out. For example, A reads B[previous] and B reads A[t+1]. Remove the forward reference
This would create a loop in this period.A period formula reads a value that depends on that same cell

In the grid, the cell message for a loop starts with This formula creates a, such as This formula creates a loop: Gross profit → Net income.

The value is in the wrong period

  • A variable that names itself without brackets reads its previous period. Write [previous] to make this clear.
  • A cell with a small ƒ mark has a period formula. Select the cell, press F2, and select Use all-period formula.
  • Actual periods show the source values, not the formula result. Check the last actual date of the model.
  • In the first periods, [previous] and [t-12] have no period to read. Check the Blanks in data setting of the variable that you read.
  • Revenue[1] is the second period, because positions count from 0.
  • "Revenue" reads several periods here — wrap it in sum() or avg() means a range is outside a function. Write sum(Revenue[t-2:t]).

The total is wrong

  • The total row of a dimension uses the dimension aggregation of the variable. To change it, select the options button (⋮) on the row, then Aggregation → Dimension. For a rate or a ratio, select Formula, not Sum.
  • Quarter and year columns use the time aggregation of the variable.
  • An item row can have its own formula. Open it and select Use parent formula to go back.
  • Revenue by Region in a variable without that dimension gives the sum of the items. A plain Revenue reads the total row.
  • A formula cannot combine dimensions: Region, Product. means that the formula uses by with two dimensions. Use one dimension, or select items in brackets.
  • Missing dimension path: "Revenue" cannot map to "Region". means that Revenue has no Region breakdown and no item link to it.

The value is not valid

MessageCause and correction
Invalid number error.A division by zero, or a result that is too large. Use if_error(Revenue / Units, 0)
Text is only valid where a formula function accepts it.Text in quotes is outside a function that takes text. Remove the quotes
currency() needs a three-letter currency code, such as "USD".The currency code is not three letters

The value does not update

When the values are not up to date, the model shows a Calculation status.

  • Calculation: Stale shows Values are from the last successful calculation.
  • Calculation: Failed shows The last calculation failed. Last successful values remain visible.
  • In manual mode, select Run calculation after your changes.

Related

  • Write a formula
  • Formula syntax
  • Time references
  • Dimension references
  • Blanks and helpers
  • Dimension totals
  • Time totals
  • Last actual date

Trash, restore, and delete a model

Move a planning model to the trash, restore it to the library, or delete it permanently.

Use a variable from another model

Link another planning model, then read its variables in formulas as Model.Variable references.

On this page

Find the errorUnknown namesSyntax errorsCircular referencesThe value is in the wrong periodThe total is wrongThe value is not validThe value does not updateRelated

Eigenn docs

current product

Overview
Overview
OverviewAccount PreferencesApproval PoliciesAssistant AutomationAssistant Command CenterAssistant Workspace and Saved WorkBank ConnectionsBilling and UsageBudgets and ForecastCommand CenterCustomer FieldsCustomer LifecycleCustomer RecordsCustomersDeveloper PlatformDocument Processing and ExtractionFiles and Document VaultFinancial Analytics and ReportsFinancial OverviewInbox and ApprovalsInvoice InsightsInvoice ProductsInvoicesMarketplace IntegrationsNotifications and BrandingOnboarding and SupportOverviewPlanning Data and DimensionsPlanning Models and FormulasPlanning Time and ActualsPlanning UncertaintyPlanning Versions and CollaborationPlanning Views and ExportsPlans and AdjustmentsReceivablesReceivables AnalyticsReceivables ControlsRolling Budget CloseScenario PlanningSecurity and AccessSettings OverviewStress TestsTeams and OrganizationsTone Profiles and ExperimentsTransaction Categories and RulesTransaction CodingTransactionsWeekly Finance RitualWorkflow ExecutionsWorkflow OutcomesWorkflow PausesWorkflows
OverviewBudget vs. ActualsBuild a Driver-Based Planning ModelBuild and Review a ForecastBuild Your First WorkflowCollaborate on a Planning ModelCompare and Share Planning ScenariosConfigure Approval PoliciesConfigure Assistant OperationsConfigure Customer FieldsConfigure Notifications and BrandingConfigure Planning Time and ActualsConfigure Receivables ControlsConnect Planning Data and ActualsConnect Transaction RecordsConsolidationCreate and Manage CustomersCreate and Send InvoicesCreate Your First Planning ModelDeveloper API SetupFirst Cash ReviewHeadcount PlanningInvoice Collection WorkflowMaintain Transaction RulesManage Security and BillingManage Team AccessManage the Invoice LifecycleMCP WorkflowsMonitor and Recover WorkflowsOrganize and Share DocumentsProcess Inbox ItemsReconcile and Categorize TransactionsRevenue ForecastingReview a Customer Finance RecordReview, Restore, and Export a Planning ModelRun a Finance Operating ReviewRun a Receivables Tone ExperimentRun a Runway Stress TestRun Planning Uncertainty AnalysisRun Your First Command Center ReviewSave and Share Assistant WorkSet Up a WorkspaceTroubleshoot Account AccessWebhook DeliveryWeekly CFO Review
Overview

Concepts

DataDimensionsFormulasScenarios

Variables

VariablesChange an input over timeCreate a variableFormat a variableOrganize variablesTime totalsUse a variable from another modelVariable types

Time

TimeLast actual dateRoll the model forwardTime granularityTime settings

Formulas

FormulasBlanks and helpersCommon formulas: cash and balance sheetCommon formulas: cohortsCommon formulas: currency and multiple entitiesCommon formulas: headcount and payrollCommon formulas: SaaS metricsCommon formulas: seasonalityConditionalsDimension referencesFormula syntaxFunctionsTime referencesTroubleshoot formulasValues with uncertaintyWrite a formula

Charts and Dashboards

Charts and dashboardsCompare scenarios and versionsCreate a chartExport and shareTablesTime aggregation in charts

Dimensions

DimensionsApply a dimensionCreate a dimensionDimension examplesDimension totalsThe Dimensions page

Data

DataChoose cash or accrual for XeroConnect a data sourceLink a variable to dataRefresh and check actualsUse transaction categories as actuals

Data Integrations

Data integrationsBank transactionsCSV importFortnoxQuickBooksStripeXero

Views

ViewsCreate and edit a viewFilter a viewShare a view

Versions

VersionsCompare versionsRestore a versionSave a version

Scenarios

ScenariosCompare scenariosCreate a scenarioPlans and adjustmentsStress tests and shocks

Collaboration

CollaborationComment on a modelShare a model and set accessTeam roles and planning access

Managing Models

Managing modelsDuplicate a modelExport a modelModel limits and performanceStart from a templateThe models home and foldersTrash, restore, and delete a model
OverviewIntegrationsMCPSDKsWebhooks
OverviewAuthenticationBank Accounts APICustomers APIErrorsForecasts and Stress Tests APIInvoice Payments APIInvoices APIPaginationRate LimitsRemote Tracker API StatusTracker Categories APITracker Entries and Timers APITracker Projects APITransactions APIWebhooks API StatusWorkflows API
Overview
Overview