Formula Column

 Top  Previous  Next

 

Formula Column

 

Creating a calculated column.

 

Steps:

 

•Open Report.
•From a Formula Column tab.
•Name of new column to be added in report. for example:NewSales
• Select type of that column.
•Select field.
•Give formula.
•Click on Ok

 

Example.

(Field name)  & Formula

(Sales) +1000

 

Screen1:

 

 

Result:

Result  in new column

example :NewSales.

 

User Guide 36