Sub Summary conditional formating

[Reid]

I have a trailing sub-summary that has a summary field in it. It calculates the total amount of hours for each of the sorted records. I'm trying to make a conditional format based on the value of the summary field but it doesn't work. It seems to only recognize the field as it's total quantity and not by each sorted record set.

Any suggestions?

[comment]

I'm trying to make a conditional format based on the value of the summary field

More details about the condition/s would be useful.

[Reid]

Conditional Formating happens when SummaryField < 7

SummaryField appears to be less than 7 but it doesn't format correctly because the SummaryField for all record is 200.

[comment]

Either one of these should work:

[Value is] [less than] [ 7 ]

Self < 7

GetSummary ( SummaryField ; BreakField ) < 7

---

If you are trying to conditionally format an object other than the summary field, only the third option will work.

Edited November 23, 2010 by Guest

[Reid]

The last one works great! Thanks so much!