AnsweredAssumed Answered

# Newbie - Lost in Value List and Calculations

Question asked by RayGerman on Jan 8, 2013
Latest reply on Jan 8, 2013 by RayGerman

### Title

Newbie - Lost in Value List and Calculations

### Post

Hello,

I am just getting my feet wet with FileMaker, so please bear with me. I am probably using the incorrect mechanism to perform this action, but with my limited knowledge of FileMaker... it is all I can come up with at the moment.

I am building a Form to calculate potential bonuses for employees and am getting stummped on how to set up the calculation

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.

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

If anyone has any input or suggestions... I would be very grateful.

Thanks,

Ray