As shown in my attached screenshot, I'm trying to print a list of records from a found set, but only those records where the value in the LEDGER::total summary field is equal to zero. Currently, the layout is showing all records, not just the records where the total field is equal to zero. I thought I could use Conditional Formatting to accomplish this. If the field's value is not equal to zero, I want to "skip" these records by changing the text colour of each the fields to white. But, I'm not getting the desired results (the result is that it white's out all records). I thought using Getsummary function in the formula would help, but no. Any ideas? Thank you from a a beginner using FMPA11v4 for Mac.

best bet is to open a new window with the found set of record, loop through and omit the wrong ones, then print the rest.

This seems to be a duplicate thread:

http://fmforums.com/forum/topic/80037-financial-account-analysis/

Thank you Vaughan and comment.

Comment, I thought I could resolve my previous thread by just approaching the problem another way by using conditional formatting on the layout that had a lot of irrelevant information. Based on Vaughan's response, I'm back where I started. It was worth a try. Thanks.