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.