isNumber

The function returns true in these scenarios:

The function returns false in these scenarios:

By default, the function recognizes a valid currency string as a number.

A valid currency string is one in which a currency symbol or ISO code appears at the string's start or end.

You can change the default behavior by setting the ACCEPT CURRENCY parameter to false.

Numeric/currency strings in your data should not include an abbreviation suffix.

The function returns false for most strings of this type, but there are two exceptions.

A recognized currency symbol can be at the end of a currency string. This is why the function parses '100K' as 100 kyats. It does not parse '100K' as the number 100,000. To avoid this, set ACCEPT CURRENCY to false.

Assume a "Describe a JSON Object" project with this data:

{
    "data": [
        {"branch": "Austin", "sales": 1345929.12, "target": 1250000},
        {"branch": "Boston", "sales": 1838534.77, "target": 1750000},
        {"branch": "Dallas", "sales": "919575.4", "target": 2000000},
        {"branch": "Denver", "sales": "no value", "target": 1750000}
    ]
}

The "data" array contains four JSON objects. The sales values for the first two objects are numbers, the sales value for the third object is a numeric string, and the sales value for the fourth object is a non-numeric string.

You might write this user-defined function (UDF) script to generate a summary for each object:

#define getSummary(object)
	
[[object.branch]] achieved sales of [[abbreviateNumber(currencyFormat(object.sales))]].

This is a UDF script, so you need to call the function in another script. For example:

[[forAll(WholeJSON.data, object -> getSummary(object))]]

This tells Studio to run all objects in the "data" array through the getSummary script. The request returns an error because the getSummary script requires a number (or a string value that can be parsed to a number) from the input object's sales key. Remember, the fourth object's sales value is a non-numeric string.

The fix is to use isNumber in a conditional statement inside the getSummary script.

#define getSummary(object)

[[isNumber(object.sales) ? "[[object.branch]] achieved sales of [[abbreviateNumber(currencyFormat(object.sales))]]." : "The sales value for [[object.branch]] is unknown."]]

Now, [[forAll(WholeJSON.data, object -> getSummary(object))]] generates a summary for each object.