Versions Compared

Old Version 1

changes.mady.by.user Rufil Cabangal

Saved on

compared with

New Version 2

changes.mady.by.user Rufil Cabangal

Saved on

Key

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

...

Note

Only Budget, Calculation, Debit, Credit, Debit Units, Credit Units , GL Trend 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. Add a row in A new row will be available in the grid areasection.
  2. In the ID field, select the column. The Description field will then show the description of the selected row.
    Image RemovedImage Added
  3. In the Action field, select an operator.
    Image RemovedImage Added

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

    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 Save toolbar button to save it. In case you miss to click this button and you click the Close toolbar button or the x button at the top right corner of the screen, i21 will prompt you if you would like to save it before closing the screenOk 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.
    Image RemovedImage Added