use Aggregate Function to refer multiple Linked Records ...? CAN'T SOLVE

I start with Sheet (A) containing lists of records, grouped by Status.
For reference I ask it to show the Average EG1.

In order to be able access the Average figure, I create another Sheet (B) where Primary Key 'Title' corresponds to 'Status' in Sheet (A). The Link is therefore populated with the 3 records, the Count counts, and the Rollup EG1 Average presents the correct average. So far so good.

Back to Sheet (A) I create Links to Sheet (B) to pull the EG1 Average ('Lookup KEEP Rollin Avg'). This is so that I can sort based on whether or not the record is above / below the Average.

My first attempt at a formula fails. 'Use an aggregate function...'

My second attempt at a formula has no Error. But the results are all over the place.

It provides YES checks for records with EG1 lower than Average. Or it provides NO checks for records that are obviously higher than average.

I have no clue how to create the formula that will do the obvious (is it obvious?!)

One work-around I considered, was to simply mirror the 'Lookup KEEP Rollin Avg'. To simply have a formula that =Equals the value of 'Lookup KEEP Rollin Avg'. I can't seem to do that either.

Can anyone point me in the right direction... How would you solve this??

Thanks for your consideration...