SWITCH Formula

[LUIS]

This is a part of the formula i've been trying to use. I have different resources associated each one to a diferent number. The thing is i have a list of at least 45 resources and the formula marks an error and i think it is because the number of charachters. Is there another formula that i can use? Is there another way to lookup this values in a table?

Thanks for the help

Switch
[Name of the Resource]="BZ",100
[Name of the Resource]="P4",200
[Name of the Resource]="P5",300
[Name of the Resource]="P6A",400
[Name of the Resource]="P6B",500
[Name of the Resource]="P7",600
[Name of the Resource]="GTO",700
[Name of the Resource]="KBA",800
[Name of the Resource]="STAHL",900
[Name of the Resource]="KL",1000)

 

[JackD]

This is a part of the formula i've been trying to use. I have different

resources associated each one to a diferent number. The thing is i have a
list of at least 45 resources and the formula marks an error and i think it
is because the number of charachters. Is there another formula that i can
use? Is there another way to lookup this values in a table?

Thanks for the help.


Switch(
[Name of the Resource]="BZ",100,
[Name of the Resource]="P4",200,
[Name of the Resource]="P5",300,
[Name of the Resource]="P6A",400,
[Name of the Resource]="P6B",500,
[Name of the Resource]="P7",600,
[Name of the Resource]="GTO",700,
[Name of the Resource]="KBA",800,
[Name of the Resource]="STAHL",900,
[Name of the Resource]="KL",1000)

Here is what I would do.
Open the resource view (the one with all the resources listed)
insert one of the text columns.
Put the number for each resource in the text column.

Now the question is what are the numbers for and which context are they used
in.
If they are used in some sort of a resource view then you are done.
If you are trying to use them in a task view you need to do something else,
where the "something else" is to write a small visual basic macro to put the
number where you need it.

If you can tell us what the number is used for and why then the next step is
easy.

-Jack