AnsweredAssumed Answered

Setting field based on two variables

Question asked by datadog on Mar 11, 2010
Latest reply on Mar 11, 2010 by 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

Outcomes