Skip to Content
author's profile photo Former Member
Former Member

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

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?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Dec 13, 2014 at 01:59 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.