Just want to confirm, can we use passed params in a formula

[Former Member]

We have a 'legacy' cr program which does certain data parsing such that the user wants to see sales by various quantity in the formula they do like

CASE

SELECT {@Product Line Group}

//

//

    CASE "Trophies":

    (

        SELECT {Command.NUM_UNITS}

            CASE 10 to 24:

                "2.  10 - 24"

            CASE 25 to 49:

                "3.  25 - 49"

            CASE 50 to 74:

                "4.  50 - 74"

            CASE 75 to 99:

                "5.  75 - 99"

           //

             CASE 100 to 149:

                "6.  100 - 149"

            CASE 150 to 249:

                "7.  150 - 249"

        DEFAULT:

            "8.  250+"  

    )

    CASE "Crystals":

    (

        SELECT {Command.NUM_UNITS}

           CASE 1 to 9:

                "1.  1 - 9"

            CASE 10 to 24:

                "2.  10 - 24"

            CASE 25 to 49:

so periodically they want to see not 1- 9 but 1 -20 etc. so then i have to code the change in the formula and send to the scheudler. To make such a table may be one way but it is not a priority for the server people at this point as they are moving away from that server slowly.

So I thought about making parameters how would you do passing param? one long string or 8 params or 16?

[ido_millet · Accepted solution]

Use a multi-value parameters.  That gives you an array that you can loop through.