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

    Need help to create calculation formula

    iamnat0212

      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  

        • 1. Re: Need help to create calculation formula
          philmodjunk

               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.