Hi,

I have a multiple select parameter and I would like to know how I can] determine how many values were selected by the user.

For example my parameter has the following values:
Red
Orange
Yellow
Green
Blue
Violet

The user selects Red and Blue. I want to know that the user has selected 2 values from this multiple select parameter.
Is there an easy way that can be accomplished?

Thank you in advance!
Kelly

This message has been edited. Last edited by: FP Mod Chuck,

Figure out how many ' OR ' there are in the Variable plus 1.

so if you have
WHERE COUNTRY EQ 'ITALY' OR 'ENGLAND' OR 'FRANCE';

then the number of values selected is 2 + 1.

Here's an example I came up with:

  
-SET &NEW_COUNTRY= REPLACE(&COUNTRY, ' OR ', '');
-SET &ORIG_LEN=&COUNTRY.LENGTH;
-SET &NEW_LEN=&NEW_COUNTRY.LENGTH;
-SET &NO_OF_SELECTIONS=((&ORIG_LEN-&NEW_LEN)/4)+1;

TABLE FILE CAR
SUM CAR.BODY.DEALER_COST
BY CAR.ORIGIN.COUNTRY
BY CAR.COMP.CAR
HEADING
"NUMBER OF VALUES SELECTED: &NO_OF_SELECTIONS"
WHERE CAR.ORIGIN.COUNTRY EQ &COUNTRY.(OR(<ENGLAND,ENGLAND>, <FRANCE,FRANCE>, <ITALY,ITALY>, <JAPAN,JAPAN>, <W GERMANY,W GERMANY> |FORMAT=A10)).COUNTRY:.;
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
ENDSTYLE
END

-RUN

This message has been edited. Last edited by: BabakNYC,