Defining Properties of Return Values
Last updated on 2025-12-11
Overview
Placeholders and functions can be extended with text and parameters to control the display of their return values. The extension is made with an arrow (->).
The return values for the Value and Exchange rate functions can be changed using any formula.
This article contains the following sections:
Return Values for Placeholders
Placeholders in tilde formulas can be assigned a text and parameters for the properties of the return values.
To define the properties of the return value of a placeholder, an arrow ( -> ) is added to the tilde formula followed by a text and/or a parameter.
Tilde Formula Structure
The tilde formula must be structured as follows:
~Placeholder->"Text %short/%long"
It is possible to attach any desired text to a placeholder. The entered text is retained when the report is generated.
The return values of the placeholders for periods and data levels can be specified with additional parameters A detailed description will be available shortly.
Keywords
The keywords %short and %long specify the return value of a placeholder as name or as full name for data level, adjustment level, and organization element.
You can only export the full name if an attribute exists in Lucanet with the long_name key and it is used in the Data level, Adjustment level, and Organization elements dimensions.
Example
The Excel worksheet contains two tilde formulas with placeholders for an organization element:
The placeholders are replaced based on the tilde formulas:
Return Values for Functions
The return values for the Value and Exchange rate functions can be changed using any formula.
Structure of tilde formulas
The tilde formula must be structured as follows:
~Rate/~Value(Parameter_1 ... Parameter_n)->"1/x"
The letter x represents the return value of the function, while 1/x represents a possible formula.
Example
The Value function in row 2 returns the unchanged value.
In row 4, the return value is changed with x/1000:
The generated report appears as follows:
