Here is the scernario:

Field Status contains the following values:  Pending, Completed, Cancelled.

MaxOrders is a function that (calculates) and displays the Total orders (regardless of their Status).  This value is displayed against each record.

 

Requirement:

 

I would like to display only the records where

1.  Status <> "Completed" and MaxOrders  > 0 and there are no records where Status = Completed.

 

2.  Status = Completed and MaxOrders > 0.

 

 

 

Here is my formula for Suppress for the field

 

if (({sp_MONTHLY_STATUS_BY_REP1.Status} <> "Completed" AND {@MaxOfTotalOrders} > 0
    AND ({sp_MONTHLY_STATUS_BY_REP1.Status} = "Completed" AND {@MaxOfTotalOrders} = 0))
 
    OR ({sp_MONTHLY_STATUS_BY_REP1.Status} = "Completed") AND {@MaxOfTotalOrders} > 0) then
false

 

 

But this still displays the records I would like suppressed. 

Your help is appreciated.