Jump to content



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
  • 25,089 posts
  • Time Online: 363d 22h 40m 38s

Posted 24 January 2011 - 08:59 PM

Use the GetSummary() function.
  • 0

FMForum Advertisers