Calculated columns are used for two reasons: One, to calculate a total between various columns. Two, to bring in multiple columns from another table.
To calculate a total between various columns:
Edit an existing column to make it a calculated column
Select a column type
Tick the 'Is this a calculated column' checkbox
You will see a calculated value line and a few tabs just below that.
Click on any of these tabs you want to include in your calculation, you can join them by clicking on any of the function icons. Depending on the column type, functions will include; +,-./,x.
Once you have your calculation, click save.
When adding new records, this column will be greyed out and calculated automatically once you save the new record.
To bring in columns from another table.
In order to bring in columns from another table, you first need to create a From Table column. Do this by:
Adding a new column to the table
Selecting From Table as your column type
Selecting the table you would like to reference from under 'select a table'
Save
This will bring in the first column of the table you would like to reference
Next:
Select a column type
Tick the 'Is this a calculated column' checkbox
You will see a Sub Columns section.
Click on the tab you want to add to your table. It will be added to the calculated value line
Click Save.
When adding new records, this column will be greyed out and calculated automatically once you save the new record.
Comments