3 Replies Latest reply on Mar 11, 2010 12:13 PM by datadog

    Setting field based on two variables

    datadog

      Title

      Setting field based on two variables

      Post

      Total newbie to FMP 10 on XP.  Chugging along great but stuck on some calculations.

       

      I want to set a field number based on the variables in two other fields.

       

      I have a field for stock that gives paper weight 30,35,50 etc.

      I have a field for size that gives paper size 22, 24, 26 etc.

      Each combination has a different weight result which I have the calculations done for

      Can I make a calculation field that says

       

      If size is 22 and stock is 30 then weight is 34.76 and

      if size is 24 and stock is 30 then weight is 37.92 and

      if size is 26 and stock is 30 then weight is 41.08 and 

      if size is 22 and stock is 35 then weight is 36.88 

       

      And so on..

      I would have 50-75 total entries for possibilities.  

      Better way to do this?

      I want to take the result (i.e. 34.76) and use it to calculate some other fields for total lbs used etc.

       

      Any and all help appreciated.

       

      Thanks,

       

      Scott