In the Excel Functions Setup page the Excel Functions are set up, which can then be selected in the Formulas of the Excel Evaluations.
The page can be opened in the Excel Report Builder Setup via the corresponding action in the Setup group.
For more information, see Setup, Excel Report Builder Setup.
Via the Download action the setup can be created or updated quickly and easily.
Note
Note that in evaluations the English Excel Function names, commas instead of semicolons and dots as decimal separators must be used. This makes the data independent of the visualization and therefore also independent of language, region and country settings.
When a user opens the workbook, the data is automatically displayed in the format he or she has set.
The help provided by Microsoft for each function as well as an overview of all functions can be displayed or opened in English and in your display language.
Fields
Name
Specifies the name of the function.
Description
Specifies information about the function.
Category
Specifies to which category the function belongs.
ID
Specifies the ID assigned to the function by Microsoft. Only if the correct ID is specified, the help for the function can be called.
Language related name fields
Specifies the name of the function in the respective language.
These fields are displayed when selecting an Excel Function depending on the display language to make it easier to search for a function or the English Excel Function name.
When setting up the formula of an evaluation, an action for translating the Excel Functions from another language is also available. The action uses the language related name fields for the translation.
Actions
Download
Via this action the Excel Functions can be downloaded and thus the setup can be created or updated quickly and easily.
Import / Export
Via Import and Export the Excel Functions can be imported from a file or exported to a file.
Help
Opens an external website that displays detailed information about the function in English.
Help (Translated)
Opens an external website that displays detailed information about the function in your display language.
Function Overview
Opens an external website that displays all functions in alphabetical order in English.
Function Overview (Translated)
Opens an external website that displays all functions in alphabetical order in your display language.
Excel Functions
Via the Download action the setup can be created or updated quickly and easily.
