Newbie FileMaker Question - Converting a Value list for a Calcualtion

[rgerman]

Hello,

 

 

I am struggling with a calculation based off a value list is FileMaker

 

In a nutshell, I have created a value list drop down menu, in which the user can select 

1,2,3,4 or 5 as a rating.

 

I need to translate these values as shown below, in order to use for a calcualtion

 

1=20%

2=40%

3=60%

4=80%

5=100%

 

 

What is the easiest way to do this? 

 

I have about 20 of these drop downs in my table. This would be simple enough in Excel, but I can’t seem to figure it out in FileMaker.

 

HELP!!

 

Thanks in Advance,

Ray

 

 

[comment]

The easiest way would be to use a calculation =

 

Rating * .2

 

 

 

I have about 20 of these drop downs in my table.

 

Sounds like you are using fields where you should be using records.

[rgerman]

Thanks for the reply...

 

I should have expanded on my question. I am trying to make this calculation based on three fields. 

 

The first field (Maximum Bonus Potential) will hold a dollar value. 

 

The second field (Company Performance Weight) which will hold a number which I would like to multiply against the first field as a percentage. I am not sure how to make the number a percentage in my calculation?

 

The third field (Company Performance Score) will have a drop down value list, of the numbers 1, 2, 3, 4 and 5.

I would like to convert the numbers in this fields for my calculation, so the number "1" actually equals "20%" The number "2" equals "40%" the number "3" = 60%" the number "4" = "80%" the number "5" equals "100%"

 

 

For example if 

 

Maximum Bonus Potential  675.00

(x times)

Company Performance Weight  50% 

(x times)

Company Performance Score  "Number 4 selected from value list"  = 80%

 

I would like the calculation to be 675 x 50% x 80% = 270.00

 

 

I cobbled this calculation together which appears horrible wrong.

 

Maximum Quantitative Bonus Potential * Company Performance Weight & "%" * Case (Company Performance Score = 1 ; "20%" ; 2 ; "40%" ; 3; "60%" ; 4; "80%" ; 5; "100%" ; )

[comment]

Filemaker does not understand the % symbol within a calculation formula. Try instead =

Maximum Quantitative Bonus Potential * Company Performance Weight * .2 * Company Performance Score

This is assuming the Company Performance Weight field contains the value of 0.5 (half), formatted to display as Percent. That is the correct way to handle percentages. If, for some reason, you prefer to enter 50 in this field, change the formula to =

Maximum Quantitative Bonus Potential * Company Performance Weight / 100 * .2 * Company Performance Score

or shortly =

 

Maximum Quantitative Bonus Potential * Company Performance Weight * .002 * Company Performance Score