Display only last 4 digits of National Identifier

JHaden3

OBIEE - Would someone please help with a formula to display only the last 4 digits from this social security number field?  The field name is "Worker"."Primary National Identifier Number"

Example:  change 123-45-6789  to 6789.  Thanks!

Srinivas Malyala-Oracle

SUBSTRING("Worker"."Primary National Identifier Number" FROM LENGTH("Worker"."Primary National Identifier Number")-3 FOR 4)

JHaden3

Thank you so much for your quick response.  You made my day!

Gianni Ceresa

Simpler and shorter: RIGHT("Worker"."Primary National Identifier Number", 4)

When you click on the "f(...)" button in the formula editor you can easily see available functions (in categories, with a short description of the function and parameters).

[Deleted User]

+1 to Gianni's solution. Why  use two nested functions that have to be parsed for every single record if RIGHT does the same job.