Jump to content


FileMaker Inc. has a deadline for users of version 10,11, 12 as Individual box or volume licenses (with expired maintenance).
If you don't renew your maintenance and upgrade to FMP 13 you will no longer be eligible to upgrade, at the discount pricing.

Volume Licensing upgrade pricing for FileMaker Pro 13, FileMaker Pro 13 Advanced and FileMaker Server 13 will be discontinued.
Individual upgrade pricing for FileMaker Pro 13 and FileMaker Pro 13 Advanced will increase after September 26, 2014.
As of 27-September-2014, FileMaker 10 products will no longer be available for purchase or support.



Conditional Formatting when breaching a number barrier first time.

  • Please log in to reply
1 reply to this topic

#1 NickFaraday4  newbie

  • Members
  • 8 posts
  • FM Application:11 Advance
  • :

Posted 24 January 2011 - 07:25 PM

Ok I have a summary report that groups a bunch of records in various sizes and have a summary count field to let me know how many records are in each grouping. Is there a way to set conditional formatting when I breach a total number of records ceiling, but only format the group at which the breach occurred?

So right now I have a field that shows a "running total" and I can set the conditional format to trip for all the records after a record number ceiling has been breached, but what I want to do is only highlight the group where the ceiling was passed not all groups after.

Any Ideas?
  • 0

#2 comment  consultant

  • Members
  • 24,191 posts
  • Time Online: 329d 3h 36m 25s

Posted 24 January 2011 - 08:59 PM

Use the GetSummary() function.
  • 0

FMForum Advertisers