How to exclude rows from your Report

How to exclude rows from your Report

Created by: Johann Du Toit

Modified on: Sat, 21 Sep, 2019 at 9:36 AM


To exclude rows from your report, you can input a filter formula in the Report section of the designer:



This normally specifies which rows to include, but you can also use the "is not" or "different than" symbol which is "<>" to specify which to exclude.


So as in the example above we can construct a formula saying:
SQL
[Customer Email] <> "john@gmail.com" AND [Customer City] <> ANY("London", "Brisbane", "Sydney") AND [Customer Country] <> NULL


Which would translate to "only include rows which do NOT have an email of john@gmail.com and which do NOT have their city as London, or Brisbane or Sydney and which do NOT have an empty Country.


    • Related Articles

    • Report Designer Formula Reference

      There are two places where formulas can be used in the report designer tool: Row Filter formula for reports Value Source formula for cells Both have the same syntax, but are used in different ways. The general formula language is inspired by the ...
    • Report Designer Excel Style Formulas

      Created by: Gavin Hodge Modified on: Fri, 14 Feb, 2020 at 9:43 AM Most formula transformations can be done using value source formulas, but the report designer tool also supports using literal Excel style formulas.  While value source formulas are ...
    • Designing a conversion rate report

      Created by: Gavin Hodge Modified on: Tue, 18 Sep, 2018 at 2:06 PM A conversion rate report is one of the more advanced uses of the report designer. It requires use of many features of the designer including value formulas, Excel style formulas, ...
    • How to pivot horizontally in the report designer

      Created by: Gavin Hodge Modified on: Tue, 18 Sep, 2018 at 2:06 PM The report designer supports pivoting data horizontally into columns. For example, you might want to group figures by month and have a column per month. This is called a horizontal ...
    • How to change Wink Report Header text and background colours Print

      Created by: Andrei Gromek Modified on: Tue, 18 Sep, 2018 at 2:06 PM Outline Wink Reports allows users to change the colour of header rows and the colour of text on the header rows on their reports. Follow these steps to change your header row ...