VisionCore How To
Home Search Support Forum Knowledge Base Print

Report: Row Calculation

From Report Menu > Financial Report Designer > Column Designer, Column Designer form will open.

FRCore_01

 

1.Column Type RowCalculation once selected will display the Formula attribute. (Same goes with ColumnCalculation)

FRCore_02

 

Selecting any other column type would otherwise display the Filter Type attribute.

FRCore_03

 

2.Row Component combobox

FRCore_04

 

Info Note: The Row Component combobox is disabled by default. The combobox will be enabled only if the combobox is empty and RowCalculation column type is selected.

 

FRCore_05

 

When you click the Formula Repository button while the Row Component combobox is empty, a validation message will appear as shown in the screenshot below.

 

FRCore_06

 

3.Once a Row Component has been selected and RowCalculation is chosen, clicking the Formula Repository button will open the Row Calculation worksheet. This form displays the All Column Type such as “Calculation, ColumnCalculation, Budget and GLTrend” and Row Type such as “Calculation, TotalCalculation and Hidden” value will be shown and arranged like Actual Report’s Layout.

FRCore_07

 

a)You can only edit the column that you are currently on when the Formula Repository button is selected. To input a formula, simply input an equal sign “=” then click the cell that you want to use for the formula followed by an operand.

FRCore_08

 

FRCore_09

 

b)When you enter an invalid formula, a validation will prompt.

FRCore_10

 

c)All formulas entered on the worksheet will be displayed.

 

d)If a chosen cell for a formula is invalid, it will be substituted to zero. This is applicable when the chosen cell is not a calculation column type i.e. None, Line, RowCodes, RowDesc

FRCore_11

 

FRCore_12

 

Generate a report using the column component where the formula was created. Click on the Generate Button.

FRCore_13

 

The generated report looks like this.

 

FRCore_14

 

e)To save changes made on the Row Calculation worksheet, you could simply click OK button or click the Cancel button to do otherwise.

 

4.Changing a RowCalculation column type to other column Types will show the message as illustrated in the screenshot below.

FRCore_15

 

See also topics: Percentage Total on FS from Report Writer and Favorable Variance Reporting for more details on how to perform calculations.