AnsweredAssumed Answered

Sum If

Question asked by tigerdad on Mar 24, 2014
Latest reply on Mar 31, 2014 by tigerdad

I am trying to create a layout/report that pulls all information off of a master record, with the exception of a few detail records that need to show on one side of the page. I have a PayAppMaster table that is related to the COMaster table. I need to sum all the records on the COMaster Table that have an approved date of last month or earlier. the first thing that jumps to mind is the sumif, similar to excel, but I can't find anything similar to this in FM12Advanced. I have googled a few custom functions, but they only take text arguments. any help or ideas would be greatly appreciated.