# 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![](https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FHrSGHwmayjWe3bPijsJr%2Fimage.png?alt=media\&token=8910ce84-82fc-4943-a374-96cc53257676)icon in the container.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2Fc0x4DjFNEpBpLY7CNAzL%2Fimage.png?alt=media&#x26;token=9bad4b2f-47d5-4db4-bb75-3fbbf54eed06" 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="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F7HypOMBAhCzpOvesscLf%2Fimage.png?alt=media&#x26;token=d2544b38-81c9-43ba-8469-b76c5c819832" alt=""><figcaption><p>Inserting text</p></figcaption></figure>

**STEP 3:** You can insert references and calculated metrics as well. Click the<img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FHhDGMNFIj7fMzcqiN5XZ%2Fimage.png?alt=media&#x26;token=5d08447b-8bd9-4814-8904-9cabcd2d6ba9" alt="" data-size="line">icon to open the formula editor.&#x20;

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FFq79nSeM1CCeRsZjGQHI%2Fimage.png?alt=media&#x26;token=fe569870-61b9-4746-b486-d3582bac926b" 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="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FgJ7I0pcODB7S57t7JimX%2Fimage.png?alt=media&#x26;token=7fd7aa6c-60d9-4eb2-b371-411e4297d21c" 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="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FP5ltdPqijQVV5ZFzjJIx%2Fimage.png?alt=media&#x26;token=e100e9d1-5c10-42fe-8cab-094ff6014c7f" alt="" data-size="line">icon to open the number formatting menu. You can set the scaling, precision, prefix/suffix etc.
* Click the<img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FdlxbE8XMClogB3GibK39%2Fimage.png?alt=media&#x26;token=d584642f-e89d-4040-9c34-660521d881af" alt="" data-size="line">icon if the result of your calculation should be converted into a percentage.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FwPtPzEIgomTpaMjaHjQ9%2Fimage.png?alt=media&#x26;token=1b8986c1-220d-4214-a51c-c14cda6bce82" alt=""><figcaption><p>Calculated KPI metrics</p></figcaption></figure>

**STEP 6:** Hover over a text container (without selecting it) and click the<img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FzAarb9eexEvU2lafEVq7%2Fimage.png?alt=media&#x26;token=a087527f-ddfb-4aba-8b38-77088faf8c66" 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="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FFGjBrQ7Hp4VoMyHZ4zVQ%2Fimage.png?alt=media&#x26;token=e99e873e-5e3a-4be0-ac7d-89111a850919" alt="" data-size="line">icon.

<div><figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FaIBaEh6D90lEh3chdxwu%2Fimage.png?alt=media&#x26;token=33ef2b96-a34b-4de3-b64a-ad18f864ac71" alt=""><figcaption><p>Bullets and numbering</p></figcaption></figure> <figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FQWkRZSP291zRVkSr76jR%2F2024-11-13_15h14_58.png?alt=media&#x26;token=ef11eac4-3f2c-48ef-856c-15a4f22f1313" alt=""><figcaption><p>Highlighting, background and font color</p></figcaption></figure> <figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FDQozApPxAPK0aAwsUWs6%2F2024-11-13_15h18_13.png?alt=media&#x26;token=9951c9c5-4c9d-4dc0-bdf4-9955759ba02a" 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="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FKlc2QZC0iCzAuljTLo28%2Fimage.png?alt=media&#x26;token=a0d157ac-56c9-4a56-a033-e34211eba3be" alt=""><figcaption><p>KPI Functions</p></figcaption></figure>

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

<div><figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F3xGggUAV2krDBgm0I5ne%2Fimage.png?alt=media&#x26;token=d6cc1553-03b4-4ada-82cf-7aac0bd8f4e3" alt=""><figcaption><p>First</p></figcaption></figure> <figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F1MjtjPSjWFzmTWrBzPU9%2F2025-02-03_17h54_42.png?alt=media&#x26;token=14cc6d4d-57cc-42a2-8e41-6f4a9a9bd75f" alt=""><figcaption><p>Last</p></figcaption></figure></div>
