How to count number of selected items in prompt/presentation variable

Question

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,

Gianni Ceresa · Answer

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.

Pedro F · Answer

Why are you asking the same thing again? You opened a thread with the same question where you got people answering your question so what's the point of a new one?

asim cholas · Answer

something like below

case when POSITION(',' IN '@{yourVariable}')>0 then 'USD' else yourcurrencycolumn end

Thanks

Aj