AnsweredAssumed Answered

Are in table related record calculations possible?

Question asked by tomperr on Jun 23, 2016
Latest reply on Jun 24, 2016 by tomperr

Within the same table and a found set, is FM capable of looking at the contents of a field in a separate record and returning results through a calculated field?

EX:  Dates within records will change, but the found set will return 1 of each color, so no conflicts will exist.

Fields-     Colors       Date                    Calc

                   Red           1/1/16             if( Color =  Red ; Date ; if (color = white ; date ; if (color = blue ; date ;  "")))

                   White         2/1/16                    "

                    Blue          3/1/16                    "

Outcomes