The ASINH() function returns the inverse hyperbolic sine of a given value. It calculates the value whose hyperbolic sine equals the input, mathematically expressed as ASINH(x) = ln(x + √(x² + 1)). The function accepts any real number and returns a value that can range from negative infinity to positive infinity. It's the inverse operation of the hyperbolic sine function.
This function can be useful to reverse-engineer the underlying growth rate from a rolling cumulative total that has scaled non-linearly over time.
Syntax
ASINH(Value)
Arguments
| Argument | Data type | Description |
| Value | Number | The numeric value for which you want to calculate the inverse hyperbolic sine. The input can be any finite number. |
The ASINH() function returns a numeric value from negative infinity to positive infinity.
Calculation engine functionality differences
This function is only available in the Polaris Calculation Engine.
Syntax example
ASINH(1.1752)
Additional information
Returns NaN when Angle is NaN.
Excel equivalent
Examples
| Formula | Result |
ASINH(-2.5) | -1.647 |
ASINH(10) | 2.998 |
Example 1: Multi-channel revenue comparison normalization
Example 2: Accounts receivable aging distortion correction
Example 3: Port congestion delay cost normalization
Example 4: Employee grievance frequency normalization across sites
