Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Extracting the Nth value from a presentation variable

Mark.ThompsonAug 10 2017 — edited Aug 10 2017

Let's imagine a presentation variable named MY_PV, that shows this value when displayed as a column formula:  Jan2017, Feb2017, May2017, Jul2017, Aug2017

Can anyone suggest a method of saying 'show me the 3rd value in MY_PV'?  In the example above, I would like that method to return the string May2017.  The answer needs to be flexible enough to allow the selection of any value without coding a nearly endless stream of locate and substring functions, so that no matter how many values are in the presentation value, it's easy to say something like 'what is the 37th value'.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details