/
How to Configure Formula for Column Calculation column

How to Configure Formula for Column Calculation column

Feb 15, 2016

The Column Calculation screen is where you configure formula for your Column Calculation column. These columns are available when you configure your formula.

  • Budget

  • GL Amounts

  • Debit

  • Credit

  • Debit Units

  • Credit Units

  • Units

  • GL Trend

  • another Column Calculation

The following will guide you on how to configure a formula column using the Column Calculation screen. 

  1. Select the columns to be part of the formula and click Apply button.

  2. The columns selected will then be added to the Calculations grid. Use the Action field to assign an operator. 

  3. Click the Preview button to see a preview of the formula you just created. Click Close to bring you back to Column Calculation screen.


    The Reverse sign for expenses checkbox at the bottom of the screen is used when part of your formula is Budget column type. See How Reverse sign for expenses checkbox works when enabled to show you how this option is being used.


  4. Once you are good with the formula, click Save and Close. 

  5. You will be back to the Column Designer screen. The formula configured will then be shown in the Column Calculation field.

     

     

  1. A new row will be available in the grid section.

  2. In the Id field, select the column. The Description field will then show the description of the selected column.

  3. In the Action field, select an operator.

  4. Repeat steps 1 to 3 as necessary to build your formula. 

  5. Click the Save toolbar button to save and Close toolbar button to close the screen and apply the formula to the selected column.

  6. You will be back in the Column Designer screen. In the Related Columns field, notice that the formula built is shown.

The Column Calculation screen is where you configure formula for your Column Calculation column.

Only Budget, Calculation, Debit, Credit, Debit Units, Credit Units and another Column Calculation columns will be available in building a formula column.

The following will guide you on how to configure a formula column.

  1. A new row will be available in the grid section.

  2. In the ID field, select the column. The Description field will then show the description of the selected row.

  3. In the Action field, select an operator.

  4. Repeat steps 1 to 3 as necessary to build your formula. 

  5. Click the Ok toolbar button to close the screen and apply the formula to the selected column.

  6. You will be back in the Column Designer screen. In the Related Columns field, notice that the formula built is shown.