Skip to Content
0

Suppression logic formula help

Jun 22, 2017 at 09:44 PM

27

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vitaly Izmaylov
Jun 23, 2017 at 03:49 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded