cancel
Showing results for 
Search instead for 
Did you mean: 

Suppression logic formula help

0 Kudos

HI All,

I want to suppress group header base on the following criteria. There are 2 tables: Main and Company

I want to suppress if Main table "Amount" = 0 and Main table Customer name <> Company table Customer name. In other words, suppress Main table Amount column = 0 AND dont suppress Customer Name exist in both tables. Hope this make sense. Many Thanks.

Frank

Accepted Solutions (0)

Answers (1)

Answers (1)

vitaly_izmaylov
Employee
Employee
0 Kudos

The question is not clear. You already mentioned the suppression formula:

MainTable.Amount = 0 and MainTable.Customer name <> CompanyTable.Customer name.

Are you saying the formula does not work? Try OR instead of AND:

MainTable.Amount = 0 OR MainTable.Customer name <> CompanyTable.Customer name.