# 4.8. Inserting formulas & text

With Analytics+, you can add context and background details to your KPI metrics by inserting text and calculated values. Let's see how!&#x20;

**STEP 1:** You can insert a text element by choosing the Text option from the Type dropdown menu or clicking the![](/files/L54QUGQ0b3j0sCPWgFrR)icon in the container.

<figure><img src="/files/ybsJTAn0cTKVr0GelnVM" alt=""><figcaption><p>Inserting a text element</p></figcaption></figure>

**STEP 2:** Double-click and key in the text. Use the rich text editor to format and style your data.

<figure><img src="/files/t37jDQE7xmhqXMGt2NC1" alt=""><figcaption><p>Inserting text</p></figcaption></figure>

**STEP 3:** You can insert references and calculated metrics as well. Click the<img src="/files/4xGEBBGI0uvjEwrd6t3C" alt="" data-size="line">icon to open the formula editor.&#x20;

<figure><img src="/files/iHRlSKHhkWeUMzHXm8CJ" alt=""><figcaption><p>Inserting calculated values and references</p></figcaption></figure>

**STEP 4:** Select the **Add title** option to insert references i.e. the measure name, measure and variance values or panel names. You can also insert the measure/variance/average/total for a particular axis category as shown.

{% hint style="info" %}
Use the # symbol to open the reference dropdown menu.
{% endhint %}

<figure><img src="/files/ldfxkWo0kUzzek2g8GCy" alt=""><figcaption><p>Reference measure, category, variance names and values</p></figcaption></figure>

**STEP 5:** Perform calculations with the Add formula option. In the formula bar, you can refer to measure/variance values.&#x20;

* Click the<img src="/files/DEnqRfNTJ4a6hXEfWIje" alt="" data-size="line">icon to open the number formatting menu. You can set the scaling, precision, prefix/suffix etc.
* Click the<img src="/files/c6FrXkQyNTpjlNXjJm0W" alt="" data-size="line">icon if the result of your calculation should be converted into a percentage.

<figure><img src="/files/Ww45cSAfO0t3EUmmCTfc" alt=""><figcaption><p>Calculated KPI metrics</p></figcaption></figure>

**STEP 6:** Hover over a text container (without selecting it) and click the<img src="/files/RUkNH8m9xjjQIPLNKvxy" alt="" data-size="line">icon to open the Edit KPI side pane. You will have additional formatting options like bullets and numbering, horizontal/vertical alignment, background color and highlighting. You can also insert links by selecting the text and clicking the<img src="/files/vu66y5YzUqwfHKlpIdhp" alt="" data-size="line">icon.

<div><figure><img src="/files/iI2hJk6HwwWGEbwtv7vQ" alt=""><figcaption><p>Bullets and numbering</p></figcaption></figure> <figure><img src="/files/qQjS8l5pTVf1kmeL29FH" alt=""><figcaption><p>Highlighting, background and font color</p></figcaption></figure> <figure><img src="/files/WWhCTdkA6ddGEdNZj1U4" alt=""><figcaption><p>Inserting links</p></figcaption></figure></div>

You can use formulas like average or total and group formulas like first, last, next, and previous.

<figure><img src="/files/SRR3hUPC7Oc9uJK3RZ8K" alt=""><figcaption><p>KPI Functions</p></figcaption></figure>

The images below show the first/last values are fetched.

<div><figure><img src="/files/rbzk9oCxAHoSuWj1kMEL" alt=""><figcaption><p>First</p></figcaption></figure> <figure><img src="/files/pJDucTuZmXPX4yAYu6o4" alt=""><figcaption><p>Last</p></figcaption></figure></div>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.inforiver.com/analytics+/working-with-analytics+/4.-cards/4.8.-inserting-formulas-and-text.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
