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%" ; )

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