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!
SUBSTRING("Worker"."Primary National Identifier Number" FROM LENGTH("Worker"."Primary National Identifier Number")-3 FOR 4)
Thank you so much for your quick response. You made my day!
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).
+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.
