$formatNumber function returns NaN.00 when null in input

[raj-work]

Hi,

We are using formatNumber to return an amount field properly formatted. But instead we are getting a "-NaN.00".

Example:
$formatNumber($number(Account.Order[0].Product[2].Price), "#0.00")
returns "-NaN.00"
in the Account example of TryJSONata.

The expected behavior is it should return a null since the inside evaluation will return a null.

[andrew-coleman]

Yep, that's a bug - thanks for reporting.

[raj-work]

@andrew-coleman - thanks for the reply. I think you are missing the following check:
// undefined inputs always return undefined
if (typeof value === 'undefined') {
return undefined;
}

[mattbaileyuk]

@raj-work Good spot! As you may have already seen, we're certainly open to taking pull requests.

[raj-work]

@andrew-coleman , @mattbaileyuk - I updated the jsonata.js and merged my changes. Please let me know if you see any issues. Thanks.