AnsweredAssumed Answered

Simple Calculations not working

Question asked by AlexXander on Feb 12, 2012
Latest reply on Feb 14, 2012 by philmodjunk

Title

Simple Calculations not working

Post

Ok I am lost as to why filemaker is doing this but in Table 1 I have

(Record #)     (Value)       (Record 1)         (Record 2)      (Record 3)

     1               2066              0                       0                    1

     2               2065              0                       0                    1

     3               2064              1                       1                    0

     4               2063              0                       1                    1

And I am making a second table with the the same field names but different calculations, and the two tables are related by (Record #). When I make Table 2 Value = Table 1::Value it returns the numbers in the right order from 2066,2065,2064,and 2063. However when I go to make the calculation  (Table 1::Record 1 + Table 1::Record 2) for Table 2 Record 1 then it return a list of 1's, and when I do the calculation (Table 1::Record 2 + Table 1::Record 3) it returns a list of 2's. So I went to see when I make  Table 2 Record 1 = Table 1::Record 1 , Table 2 Record 2 = Table 1::Record 2 , and Table 2 Record 3 = Table 1::Record 3

Table 2 Results

(Record #)     (Value)       (Record 1)         (Record 2)      (Record 3)

     1               2066              0                       1                    1

     2               2065              0                       1                    1

     3               2064              0                       1                    1

     4               2063              0                       1                    1

 

Does anyone know what is happening

Outcomes