Yes, I admit it, I am a newby to FileMaker, converting from MS Access. I have a question, which I will very much over simplify to make it simple (I think?) Running FileMaker on a Mac.
Lets say I have a database with the following three fields (columns):
Month (Jan, Feb, Mar, etc)
Serial Number (alpha numeric which can be matched month to month)
Dollars (Different amounts per month per serial number)
What I am looking to do is compare two (or more) months, matching serial numbers, and finding the dollars difference (in percentage) or flag dollar differences greater than say 10% per serial number.