2 Replies Latest reply on Feb 14, 2012 8:44 AM by giorgosliadis

# Multiplying custom values

### Title

Multiplying custom values

### Post

Hello all!

I have a drop- down list with numbers (1,2,3,4,5) let's call it "numbers".

And then I have another drop-down list with custom values (A,B,C,D...) let's call it "codes"

I want to create a "result" field to get a specific value.

A general type of what I want to do is numbers*codes=result

Every code must have a specific, unique value, such as A=100, B=125, C=134, D=346 and so on. Note that these values are always the same. A will always equal 100.

Examples

numbers = 1 * codes = B, result = 125

numbers = 3 * codes = C, result = 402 etc...

How should I proceed? I am a newbie, so please be thorough...

Thank you very much!

• ###### 1. Re: Multiplying custom values

Numbers * Case ( Code = "A" ; 100 ;
Code = "B" ; 125 ;
Code = "C" ; 134 ;
Code = "D" ; 346 )

You can also set up a table of code letters and their values. This table can replace the custom values value list as your list of values and you can then set up a relationship matching a code field in your main table to a code table in your look up table to use to match a code to a value in this calculation. This is how a typical invoice solution multiplies a quantity times a unit price that is looked up from a products table when the user specifies a ProductID (your "code" ).

• ###### 2. Re: Multiplying custom values

Thank you very very much! You helped a lot! Thank you again!