4 Replies Latest reply on Mar 11, 2010 9:25 AM by datadog

    calculation based on other entries

    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