Strings, Numbers and Currency Functions

All the functions are in camel case. The following is the sample JSON will be used in the examples

The following is the sample JSON for all the examples

data = {
    "company_name": "Nakatomi Trading Corp",
    "total_amount": 82542.56,
    "date": "2021-09-30",
    "items": [
                {
                    "name": "Brand Guide",
                    "man_hour": 2,
                    "unit": "hour",
                    "unit_price": 120.0,
                    "item_total": 240.0
                },
                {
                    "name": "Software Development",
                    "man_hour": 17,
                    "unit": "hour",
                    "unit_price": 20.0,
                    "item_total": 340.0
                },
                {
                    "name": "Landing Page Design",
                    "man_hour": 5,
                    "unit": "hour",
                    "unit_price": 20.0,
                    "item_total": 80.0
                }

            ]
}

Number Functions

max

It returns the largest-valued number.

Usage

max(`field`, `array`)

Parameters

Example

{{ max("man_hours", data.items) }}

Output

17

min

It returns the lowest-valued number.

Usage

min(`field`, `array`)

Parameters

Example

{{ min("man_hours", data.items) }}

Output

2

sum

It returns the sum of values.

Usage

sum(`field`, `array`)

Parameters

Example

{{ sum("man_hours", data.items) }}

Output

23

sumArray

It returns the sum of values.

Usage

sumArray(`numeric_array`)

Parameters

Example

{{ sumArray([1,2,3,4,5]) }}

Output

15

average

It returns the average value

Usage

average(`field`, `array`)

Parameters

Example

{{ average("man_hours", data.items) }}

Output

8

asArray

It flattens the values of the field of arrayas a single-dimensional array.

Usage

asArray(`field`, `array`)

Parameters

Example

{{ average("man_hours", data.items) }}

Output

[2, 17, 5]

count

It returns the size/length of an array.

Usage

count(`array`)

Parameters

Example

{{ count(data.items) }}

Output

3

String Functions

upperCase

It converts the specified string to uppercase letters.

Usage

upperCase(`strval`)

Parameters

Example

{{ upperCase(data.company_name) }}

Output

NAKATOMI TRADING CORP

lowerCase

It converts the specified string to lowercase letters.

Usage

lowerCase(`strval`)

Parameters

Example

{{ lowerCase(data.company_name) }}

Output

nakatomi trading corp

isNullOrEmpty

It indicates whether the specified string is null or an empty string ("").

Usage

isNullOrEmpty(`strval`)

Parameters

Example

{{ isNullOrEmpty(data.company_name) }}

Output

false

ifNull

It returns a specified value(nullValueReplacement) if the input(val) is null, undefined or empty.

Otherwise, this function returns the original value(val).

Usage

ifNull(`val`, `nullValueReplacement`)

Parameters

Example 1

{{ ifNull(data.unknownField, 'N/A') }}

Output

N/A

Example 2

{{ ifNull(data.company_name, 'N/A') }}

Output

Nakatomi Trading Corp

truncateString

It truncates a string to the specified length.

Usage

truncateString(`strval`, `length`, `ending`)

Parameters

Example

{{ truncateString(data.company_name, 10) }}

Output

Nakatomi T...

Format number

format

It formats a number and returns a formatted string.

Usage

format(`number`, `type`, `format`)

Parameters

Number format

Currency format

Visit numeraljs for details

Example

{{ format(data.total_amount, "number", "$0,0.0000") }}

Output

$82,542.5600

Use Numeral library to format

Use Numeraljs in the expression

Visit numeraljs for details

Example

{{ numeral(1000).format('0,0') }}

Output

1,000

Format currency with locale

Usage

{{ Number(`numeric_value`).toLocaleString(`locale`, {minimumFractionDigits: 2}) }}

Syntax

{{ Number(123400.89).toLocaleString('de-DE', {minimumFractionDigits: 2}) }}

Output

18.923.400,89