HubSpot

https://knowledge.hubspot.com/

Admin

HubSpot is a customer relationship management (CRM) platform providing software tools for inbound...

Tokens:8,465,738

Snippets:57,426

Trust Score:10

Update:1 month ago

Show doc for...

Tokens:

Raw

### Numerical function examples (ABS, CEIL, DIV0, EXP, FLOOR, LN, LOG, POWER, SQRT, WIDTH_BUCKET)

Source: https://knowledge.hubspot.com/data-management/build-and-activate-datasets-in-data-studio?hubs_content=knowledge.hubspot.com%2Fimport-and-export%2Funderstand-the-import-tool&hubs_content-cta=dataset-imports

Examples of the ABS, CEIL, DIV0, EXP, FLOOR, LN, LOG, POWER, SQRT, and WIDTH_BUCKET functions. Each example shows the function call and its returned value. Use these to understand the syntax and expected results for each numerical function.

```text
ABS(-10)
= 10
ABS(10)
= 10
```

```text
CEIL(3.14)
= 4
CEIL(EXP(1))
= 3
CEIL(LN([DEAL.amount]))
```

```text
DIV0(5, 2)
= 2.5
DIV0(5, 0)
= 0
DIV0([DEAL.amount], DATEDIFF("DAY", [DEAL.createdate], [DEAL.closedate]))
```

```text
EXP(1)
= 2.718281828459045
EXP(0)
= 1
```

```text
FLOOR(3.14)
= 3
CEIL(EXP(1))
= 2
FLOOR(LN([DEAL.amount]))
```

```text
LN(1)
= 0
LN(EXP(1))
= 1
LN([DEAL.amount])
```

```text
LOG(10, 1)
= 0
LOG(10, 10)
= 1
LOG(10, [DEAL.amount])
```

```text
POWER(2, 10)
= 1024
POWER(100, 0.5)
= 10
POWER([DEAL.hs_arr], 2)
```

```text
SQRT(100)
= 10
SQRT([DEAL.hs_arr])
```

```text
WIDTH_BUCKET(25, 0, 100, 10)
= 3
WIDTH_BUCKET(95, 0, 100, 10)
= 10
WIDTH_BUCKET(-1000, 0, 100, 10)
= 0
WIDTH_BUCKET(9999, 0, 100, 10)
= 11
WIDTH_BUCKET([DEAL.amount], 0, 10000, 1000)
```

Tokens:

Raw