Versions Compared

Old Version 4

changes.mady.by.user Rufil Cabangal

Saved on

compared with

New Version 5

changes.mady.by.user Rufil Cabangal

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  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. 

    Info

    Notice as you work on adding rows and assigning an operator, the Preview field at the bottom of the screen will show you the configured formula. In that way, you have a better view while you are building the formula.

    Note

    You will not be able to close the Column Calculation screen until a formula is configured. If you unintentionally selected the Column Calculation column type, then you may click the Delete toolbar button so you can close the Column Calculation screen without having to configure a formula. This will then delete the column calculation column added.

  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.

 

Expand
title14.4

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

Note

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. 

    Info

    Notice as you work on adding rows and assigning an operator, the Calculation field at the top of the screen will show you the configured formula. In that way, you have a better view while you are building the 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.
     

 

...