AnsweredAssumed Answered

Newby needs help, please

Question asked by sseelbinder on Dec 21, 2015
Latest reply on Jan 25, 2016 by BruceRobertson

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.

Outcomes