For AI agents: an index of this documentation is at https://developer.rippling.com/llms.txt. Public pages have a Markdown version at the same URL with .md added.

Skip to main content
Developer Resources
index

CURRENCY_AMOUNT() Function

Use with AI:Rippling AI ChatGPT Claude Cursor

Description​

Extracts the numeric amount from an rp_currency value.

Aliases: CURRENCYAMOUNT

Syntax​

CURRENCY_AMOUNT(expression)

Parameters​

ParameterDescriptionData TypeRequired
expressionColumn or expression to evaluateCurrency V2Yes

Example​

SELECT
    CURRENCY_AMOUNT(annual_salary_equivalent)
FROM
    rippling.employee.Employee;