Condition List

[Jim_Shelton]

I have a found set where records show a cost value, tableA::Cost. and a color, tableA::Color.

I need a calculation for a script that list the Cost for all records where color = red. Example 2, 3, 5, 6, 8

My thought is to set a variable of each list as I need for color = red, blue and green

thanks,
Jim

Warning: This is an Old Thread This discussion is older than 420 days. information contained in it may no longer be current

[Techphan]

Make a table where all colors and their corresponding costs are contained.

Example
Red...2
Red...4
Red...5
Blue..3
Blue..5
etc.


Create a new global field called "Color." Make a value list from the table and use the global field for the "Include only related values..." setup step. Use a script trigger "On Object Modify" such that when the color is chosen, the global color field is set with the chosen color.
For more information on "Conditional Value Lists" go to the 2nd post of this thread.

[Jim_Shelton]

I tried a script that looks like this:
Go to Record/Request/page [first]
Loop
If (TableA::Color=Red)
Set Variable [$Red ; value: $Red & TableA::Cost & ","]
ElseIf (TableA::Color=Blue)
Set Variable [$Blue ; value: $Blue & TableA::Cost & ","]
ElseIf (TableA::Color=Green)
Set Variable [$Green ; value: $Green & TableA::Cost & ","]
Go to Record/Request/Page [next ; exit after last]
End Loop
Set Field [$Red ; value: Left ( $List ; Length ( $List ) -1 ) //strip off the extra comma]
Set Field [$Green ; value: Left ( $List ; Length ( $List ) -1 ) //strip off the extra comma]
Set Field [$Blue ; value: Left ( $List ; Length ( $List ) -1 ) //strip off the extra comma]

[Techphan]

So you do NOT need a value list (my error there), but a script that gives you a final list after the script is run?

Edit: Instead of using this command line in the script -->Set Variable [$Red ; value: $Red & TableA::Cost & ","]

why not use ---> Set Variable [$Red ; value: $Red & ¶ & TableA::Cost]
?