# Other Calculation Functions

There are other functions that can help you create complicated calculations.

<figure><img src="https://1304574535-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe2zyseN6XFBaLs6YTcnd%2Fuploads%2Fr2Toq1BCy4BGxWb9B0jE%2Fimage.png?alt=media&#x26;token=51d9e323-34a1-4d27-8fa6-17d006eb7b1e" alt=""><figcaption><p>Other calculation functions</p></figcaption></figure>

{% tabs %}
{% tab title="Exponentiation (  X^2 )" %}
Exponentiation is a **mathematical operation** where a number (called the **base**) is multiplied by itself a certain number of times. Formula -> **COLUMN\_NAME \*\* EXPONENT**

<figure><img src="https://1304574535-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe2zyseN6XFBaLs6YTcnd%2Fuploads%2FzRDxFGi5M4rC5FqkEXFQ%2Fimage.png?alt=media&#x26;token=22c25d8a-0e3f-4df1-8cbc-57a569f9db24" alt=""><figcaption><p>Exponentiation</p></figcaption></figure>
{% endtab %}

{% tab title="Square Root ( √ ) " %}
The **square root of a number** is that factor of a number which when multiplied by itself gives the original number. Formula -> **RESULT = COLUMN\_NAME \*\* (1/2)**

<figure><img src="https://1304574535-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe2zyseN6XFBaLs6YTcnd%2Fuploads%2FWoajOTxt9GnaZAPKk4gn%2Fimage.png?alt=media&#x26;token=3606c2c5-eb4d-454d-9a34-c068f2b75e07" alt=""><figcaption><p>Square root of a field</p></figcaption></figure>
{% endtab %}

{% tab title="Brackets ()" %}
These define the order in which operations are carried out based on **PEMDAS** or **BODMAS.** Illustrated below are the differences in the calculation **column + 10 \* 5** and **(column + 10) \* 5**

<figure><img src="https://1304574535-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe2zyseN6XFBaLs6YTcnd%2Fuploads%2FY3I0Qoez4eGqpazHpOQn%2Fimage.png?alt=media&#x26;token=aab5fef7-3446-4cb2-99f1-05883bad523b" alt=""><figcaption><p>column + 10 *5</p></figcaption></figure>

<figure><img src="https://1304574535-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe2zyseN6XFBaLs6YTcnd%2Fuploads%2FnEVXVpK0TtbyecleKcCM%2Fimage.png?alt=media&#x26;token=10f26763-1873-4e33-86b8-91beb0263e27" alt=""><figcaption><p>(column + 10) * 5</p></figcaption></figure>
{% endtab %}

{% tab title="ABS (Absolute)" %}
This function is already well explained in [absolute-function](https://docs.infotopics.com/supertables/guides/setting-up-calculations/absolute-function "mention")
{% endtab %}

{% tab title="Round " %}
This function rounds off the result to the nearest whole number.

<figure><img src="https://1304574535-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe2zyseN6XFBaLs6YTcnd%2Fuploads%2Fxnnd7s7tRN0oW4wAhyHY%2Fimage.png?alt=media&#x26;token=7550971f-3fdb-4741-b204-9f9f62e8d758" alt=""><figcaption><p>Rounding off</p></figcaption></figure>
{% endtab %}
{% endtabs %}