AnsweredAssumed Answered

Multiplying custom values

Question asked by giorgosliadis on Feb 13, 2012
Latest reply on Feb 14, 2012 by giorgosliadis


Multiplying custom values


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.


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!