1 Reply Latest reply on Oct 21, 2013 11:35 AM by philmodjunk

Need help to create calculation formula

iamnat0212 Oct 19, 2013 6:28 AM

Hello,

I have just use filemaker to create database to collect my work. I have a problem to create a calculation for one of my item.

This is list of my value list that put in pop-up menu and I want to translate to score on the right. What calculation formula I should try.

Other 20

0 degree -15

1 degrees -12

2 degrees -9

3 degrees -6

4 degrees -3

5-10 degrees 0

11 degrees -3

12 degrees -6

13 degrees -9

14 degrees -12

15 degrees -15

Thanks for your help

1. Re: Need help to create calculation formula

philmodjunk Oct 21, 2013 11:35 AM (in response to iamnat0212)

I would not recommend that you use a calculation.

Instead, define a table with the above data in two fields. Define a relationship matching the data in the first column of this new table to your value list formatted field. Now the value in the second table can be either looked up (copied) into a corresponding field in your original table or you can directly reference this field via the relationship.
Like Show 0 Likes(0)

Actions