Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 40 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 18 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
How to count number of selected items in prompt/presentation variable
Hi Experts,
Is there any way we can count number of selected values in prompt/presentation variable?
Requirement is:
When user select single country,currency prompt should display appropriate currency code values.
If user select more then one country ,then currency prompt always should be USD.
Thanks,
Answers
-
cant you find(locate) the comma in the variable data and assign USD if you find a comma in the variable value?
0 -
something like below
case when POSITION(',' IN '@{yourVariable}')>0 then 'USD' else yourcurrencycolumn end
Thanks
Aj
0 -
How to limit prompt based on other selected prompt values(Single/Multiple)
What's the point of this new thread asking the same thing for which you got an answer on the original one? Instead of losing your time in new thread keep following up on the original one.
You got the answer there already.
0
