Docs / Excel Report Builder / Edit Evaluations / Tips & Tricks Get data via sheet reference
2024/10/24 • 1 min. to read
Example
A list of all customer bank accounts and their IBAN country names should be created.
So first add a data sheet with the
Customer Bank Account table and the
IBAN field.
Then set the
Text Formatting in the
Field Settings of the IBAN field:
The text formatting causes only the first two digits of the IBAN to be displayed.
In addition, the field has been assigned the
Formula ID [CC]. Optionally, a descriptive
name can also be assigned.
After that, another data sheet with the
Country/Region table must be added to the evaluation.
This data sheet contains all country codes and their names. CCNames was given as the
Sheet Name.
The country name for the IBAN can now be determined in the
Customer Bank Account data sheet using a formula:
The example can be downloaded in the
Download Area.