AnsweredAssumed Answered

calculation based on other entries

Question asked by datadog on Mar 10, 2010
Latest reply on Mar 11, 2010 by datadog

Title

calculation based on other entries

Post

New to FM 10 Win XP.  Trying to figure out how to auto calculate a field where there are 3 variables.

Here is what I am trying to do:

field a is number of pages

field b is number of master pages

field c is type of page (even, double or 4x

 

field a is user entered number

field b is what I am trying to calculate

field c is a drop down menu with the three choices (even, double or 4x)

 

if a = 4 pages and c= even pages then i want b to be the same result as a

if a = 4 pages and c= double pages then i want b to be 2 times the number in a

if a= 4 pages and c= 4x pages then I want b to be 4 times the number in a

 

Can't seem to get this figured out.  Any help greatly appreciated.  Sorry if I have left anything out or if not explained well.  I am brand new to FMP.

 

Thanks,  Scott

Outcomes