Data Modella
  • Introduction
  • Concepts
    • Models
    • Calendar
    • Lists
    • Structure
    • Scenarios
    • Inputs
    • Variables
    • Capital
    • Elements
      • Fixed
      • Variable
      • Event
      • Matrix
    • Templates
    • Schedule
    • Pivot Views
    • Calculator
    • Actuals
  • Explanations
    • Tag Matching
    • MARC Costing
  • FAQs
    • Common FAQs
    • Support and Feedback
  • Blog
    • Improved Calculator and Variable System
    • New Inputs Page
  • Tutorials
    • Using the PowerBI Connector
    • The Building Blocks
    • Elements and the Rule of Four
Powered by GitBook
On this page

Was this helpful?

  1. Concepts

Actuals

Overlaying Actual

PreviousCalculatorNextTag Matching

Last updated 7 months ago

Was this helpful?

In Data Modella you can overlay actuals (actual recorded values) over the schedule results.

To enable Actuals for a scenario. Edit the Scenario, Turn on using actuals and select the final period you have actuals for.

Once Actuals are enabled, you can choose to Zero or Override the values by configuing the Actuals field for an Element.

If you select Override, Data Modella will look for an Input Set named "Actuals" containing an Input with the same name as the Cost Element. If one is found those values will be used for the periods that actuals have been configured for. Otherwise if there is no matching variables, the values will show as zero.

Schedule with the first three periods showing actuals
Scenario Configuration Page
Actuals field set to Override