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.