Title
Need help to create calculation formula
Post
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
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.