Alerter if row is greater than average for the group

[BobSuruncle]

How can I create an Alerter that will show the value in a cell in RED if it is Greater than the Average value for a Group?
I have a field called "Elapsed".
I've Inserted a Break on another field "Location".
I've created a summary which is the Average of Elapsed for each Break on Location.
I'd like to display the detail line Elapsed in red if it is greater than the Average.

Thanks.

Bob Suruncle

 

[blom0344]

Define a check variable like:

= If <value> > (Average(value) in (<Location>)) Then 1 else 0

Now define alerter on the check variable

Ties Blom

 

[BobSuruncle]

Thanks so much for the help.

I'm dealing with BOE XI R2 and a Webi doc (which I should have mentioned in the beginning).

I had to modify your formula a bit, as there doesn't seem to be an "IF THEN ELSE" in the formula editor.

= If( [Elapsed] > (Average([Elapsed]) In ([Ap Location])); 1 ; 0)

I then applied this to my field, and voila! Success!
Thanks again!

Bob Suruncle