Help & Support ↗ Lucanet Learning Space ↗
Getting Started
Global Functions
Lucanet Lume
Data Hub
Administration
Extended Planning & Analysis (xP&A)
xP&A Video Tutorials
User Roles in Lucanet xP&A
Lucanet xP&A User Interface
All Steps at a Glance
Basic Concepts and Elements
Creating a Model
Integrating Data
Modeling Your Data
Creating and Editing Variables
Using Sections
Using Groups
Moving Variables
Referencing Variables From Linked Models
Aggregation Functions
Relative Time for Variables
Creating Variables Using AI
Creating and Editing Formulas
Working with Time
Using Dimensions
Using Currency and Currency Translation
Viewing and Visualizing Data
Working with Models
Using Comments and Descriptions
Comparison: xP&A vs. Excel Performance
Consolidation & Financial Planning
ESG Reporting
Disclosure Management
XBRL Tagger
Lease Accounting
Banking & Cash Management
Data Collection
Tax Compliance & Reporting
Glossary

Using Relative Time for Variables

Overview

Sometimes variables do not refer to specific calendar time steps of your model (Jan 2022, Feb 2022) but refer to relative time (Month 1, Month 2). In this chapter, you get to know how to format a variable as a relative time.

How to Change Variables to Relative Time

You can format variables as relative time by heading to the format menu. Proceed as follows:

1

Click the pencil icon next to the variable name.

2

Click Format or use Cmd/Ctrl+K.

3

Activate the check box Relative Time.

Using relative time for a variable
4

Relative time steps are displayed in the cells (e.g. Mo 1, Mo 2), as well as in the drop-down list in presentation mode.

Note: If you import or reference a relative time variable in a model, it will always obey relative time, i.e. it will align with the time step it is associated with, regardless of the model start date.

For example, if you have Month 1 Retention of 100% with a model start date of Jan 2021, and then import that variable into a model that starts in Jan 2022, that retention variable will still align with Month 1 (which is now Jan 2022 in calendar time).

This content was generated using AI and reviewed by Lucanet subject matter experts before publication.

Last updated on May 1, 2026

Table of Contents
OverviewHow to Change Variables to Relative Time
Related Articles

Company

Legal Notice

© Copyright 2026 - Lucanet AG