AnsweredAssumed Answered

Need help to create calculation formula

Question asked by iamnat0212 on Oct 19, 2013
Latest reply on Oct 21, 2013 by philmodjunk

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  

Outcomes