How to Add a Formula Column to a Report

How to Add a Formula Column to a Report

Created by: Geraldene Sibi de la Torre

Modified on: Mon, 12 Aug, 2019 at 3:16 PM


Creating a custom calculation is basic functionality included in the Wink Reports Report Designer which can be easily applied by adding a formula column.



Follow these steps to add formula column:



1. From the report designer, select LAYOUT.




2.  Click "ADD FORMULA COLUMN"


You will notice that "Formula Column 1"  is added to the end of the columns by default. You can drag this column to rearrange if required.



"FORMULA COLUMN 1"  is also automatically added to your reporting data.





3. CUSTOM FORMULA CREATION


  •  Click the "gear icon" as below.



Then change/edit:




4. Your Formula Column is now successfully added to your reporting data


    • 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 ...
    • Designing Your First Report

      Created by: Gavin Hodge Modified on: Tue, 18 Sep, 2018 at 2:06 PM This tutorial will take you step-by-step through creating a spreadsheet report using the Wink Reports designer tool. It assumes you have already logged in, created an organisation, and ...
    • 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, ...
    • 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 ...
    • 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 ...