10 Replies Latest reply on Jul 1, 2013 9:59 AM by philmodjunk

    Multiplication error

    WesleySantiago

      Title

      Multiplication error

      Post

           My exercise database has two tables. One is dedicated to lifts, the other is for weight.

           Inside the main lifts table, I'm trying to multiply field repetitions (a number value) by weight (another number value) and getting incorrect results. The weight field is a pop-up field pulling values from the weight table. As I understand it, filemaker is multiplying true repetitions by the ID reference of weight, not weight itself.

           What's the best way to correct this?