Calculations in Explore can create complex expressions that combine numeric constants and variables with functions, arithmetic and logical operators. Calculations that use other columns (DataSource columns or other Calculation columns) can help you build out powerful calculations and leverage the live data connection CoolPlanet OS has.
Good Practice Tips:
Have one or more DataSource columns before creating your Calculation Column.
Please fill in the fields descriptively to make them easy to understand.
Write a clear, concise description, even though it is optional.
Creating a new Calculation Column
Step 1 - Create a Calculation Column
Click on the Add Columns in the GridBar and select the option to add a Calculation Column. This brings up the Add Calculation Column window.
Step 2 - Input a Calculation
Input calculation information into the Calculation Formula field and fill out the fields related to the Calculation Column Properties under it.
Tip:
3 ways to input your Calculation Formula
You can write the complete calculation or use one of the many prompts to help you achieve this.
Manually type out the formula.
Click on the Column or Function elements to input elements into the input.
Ctrl + Space to receive prompts about the formula elements available to you.
Learn about the Calculation Column editor's layout at:
Step 3 - Save the Calculation
Save the calculation by clicking on the BUTTON.
Edit an existing Calculation Column.
Once created, you can access the edit option by:
double-clicking the header or
choosing Edit Calculation from the column header's context menu.
Double Clicking on the Calculation Column header
Choosing Edit Calculation
Related Pages
Learn more about the Calculation Column Editor Layout
How do I use a calculation in another DataGrid: Reference Columns