System Calculations
The following calculations are available on the Quick Calculation > System menu.
| To | Do This |
|---|---|
| Get the relative sequence of a grouped row. For example, the first row in a group has a group row index of 1, the second row has a group row index of 2, etc. | Right-click on grouped Column Header. Click Quick Calculation | System | Group Row Index |
| Get the relative sequence of a row. For example, the first row in the grid has a row index of 1, the second row has a row index of 2, etc. | Right-click on any Column Header. Click Quick Calculation | System | Row Index |
| Get group ranking from largest to smallest. | Right-click on grouped Column Header. Click Quick Calculation | System | Group Rank |
| Convert a column from one data type to another | Right-click on Column Header. Click Quick Calculation | System | Type Converter. Double-click the Column Header of the newly created column. Change Output Type to desired value. |
| Convert a column to a string and maintain the input column's custom format (such as a custom date format with time) | Follow the same steps as above to create a Type Converter calculation but also make sure to check the Use Input Column Format option. |