How to configure Add Formula options

Version: Yurbi v12

Role: Builder or higher

Permission: Builder access to the application


Overview

This guide is structured to provide a step-by-step walkthrough for using add formula within your reports.  We will talk about how to the add formula option, how to configure them, and how to edit them. Lastly, a use case application will be given to have the user understand where this option can be applied.

This documentation is ideal for users who need to perform complex data analysis, generate more insightful reports, or simply wish to tailor reporting metrics to better suit their business needs.

Reminder that if you click and insert the pre-built formulas it will automatically set the data type correctly. But if you manually type in a formula you do want to make sure you set it correct (to a num for example if you added a function that will return a number).

Configuring Add Formula

1. Go to the report field and select the field you wish to configure.

A screenshot of a computerAI-generated content may be incorrect.

2. Click on the click the three dots button.

A white background with black textAI-generated content may be incorrect.

3. Select Add Formula option

A screenshot of a computerAI-generated content may be incorrect.

Adding Formulas

1. Select Data Type from the drop-down menu. By default, the shown data type is dependent on what data the selected report field has.

A screenshot of a computerAI-generated content may be incorrect.

Note: There will be cases where you want to change the data type and not insert any formula at all. For example, if you have numbers that are really currencies and want to show the currency symbol and display it like currency, you add formula, set the data type to CUR. If you have a date that includes the time portion, you add formula and set to DPO to display the Date Part Only.

Here is an in-depth article about the different data types within Yurbi.

2. Under Formula field, Select Function Type by inputting @.

A screenshot of a computerAI-generated content may be incorrect.

3. Select corresponding Function

A close-up of a textAI-generated content may be incorrect.

A screenshot of a searchAI-generated content may be incorrect.

3. Click Save

A blue rectangle with white textAI-generated content may be incorrect.

4. Click Save & Apply

A blue rectangle with white textAI-generated content may be incorrect.

5. You can see below the report field the newly configured formula for that field.

A screenshot of a computerAI-generated content may be incorrect.

Editing Add Formula

1. Click on the click the three dots button.

A white background with black textAI-generated content may be incorrect.

2. Select Add Formula option

A screenshot of a computerAI-generated content may be incorrect.

3. Configure based on your needs.

A screenshot of a computerAI-generated content may be incorrect.

To erase a part of the formula, simply use backspace until the value of the selected part is gone or highlight the part you want to delete and press delete or backspace.

To erase everythingclick Clear.

A white rectangle with black textAI-generated content may be incorrect.

After configuring, Click Save & Apply

A blue rectangle with white textAI-generated content may be incorrect.

Remember to save your report once you are done configuring.


And there you have it! You now know how to configure an add formula option and apply it to the report you are building!