Propagate sparse data with ‘Most recent value’

Some data sources only report values once — like a CRM deal created in December, or a signup logged in March. But when you're modeling over time, that data still matters months later.

Until now, pulling those values forward meant writing complex formulas like:

max(DB.Contract_Start [This Segment] [LastMonth], sum(ExtQuery.CONTRACT_START [This Segment] [ThisMonth]))

Those were hard to explain, and even harder to maintain.

Now it’s built into Runway.

• A new Most recent value option is available in the time range drop-down when editing driver formulas or configuring a database.
• When enabled, it carries forward the  last non-null value, to fill in empty months in the time series.
• It works with all driver types — whether from integrations or database columns.

Use this when modeling with sparse data, modeling contracts over time, or applying cohort curves to historical values. You'll find the toggle in any formula's time range filter, or in the Database configuration panel.