Crystal Reports Suppress not working

Message

     hello ALl,

I need some help here.

When I am trying to suppress MISSED data, it is not doing the suppress.

I am using Formula "Date" 
if {Table.MeasurementStatus} = "Met" then "Met" else "Missed"

In the sub-report I have used this formula in Group footer.
 Basically, I need to display only MET results and hide all the missed.

I used Suppressed in Format Formula editor --> Common --> Suppress
{Table.MeasurementStatus} = "Missed" 