Getting Started In This Chapter


Viewing/Editing Existing Columns



Download 12.14 Mb.
Page58/209
Date08.07.2018
Size12.14 Mb.
1   ...   54   55   56   57   58   59   60   61   ...   209

Viewing/Editing Existing Columns


Once a column has been added to the template definition, only limited information can be edited, regardless of whether the template has been saved. However, it is possible to edit formulae, as shown in the following table.


Formula

Operand

Age at Result

Column

Current Age

Date

Difference

Column 1

Constant 1

Column 2

Constant 2

Division

Column 1

Constant 1

Column 2

Constant 2

Equals

Column

Constant

Grade Tally Columns

Column 1

Grade

Grade Tally Historic

Aspect

From Date

To Date

Comparison

Grade

IF THEN ELSE

Column 1

Constant 1

Comparator

Column 2

Constant 2

Then Column 1

Then Constant 1

Else Column 1

Else Constant 1

Marks to Grade

Column




Grade and Marks

Mean

Columns

Multiplication

Column 1

Constant 1

Column 2

Constant 2

Percent

Column

Plus

Column 1

Constant 1

Column 2

Constant 2

Position

Column

Prediction

Line

Column

Percentile Score

Sum

Columns

Value

Columns

Max

Columns




Max

NOTE: Formulae of an imported template cannot be edited.

  1. To view/edit column properties, either double-click the Column Name, or click the Column Name, then click the Open button to display the Column Details dialog.



Open button

  • For all columns, the Column Heading can be amended as required.

  • For Data Review columns it is possible to change the date range together with which result should be shown (i.e. Recent, Highest, Lowest or Mean). In addition, you can hide the column by selecting the Hidden check box. This would normally be required if this column was being used in a calculation and you did not want the column to be displayed in the marksheet.

NOTE: Hidden columns are not exported to Excel.

  • For all formula columns, you can view the structure of the formula by clicking the View button, which opens the Formula Detail dialog.

  • For Data Entry Formula columns, you can change the read-only status by selecting or deselecting the Read-only check box. Your choice will depend on whether you wish to allow users to overtype a calculated result.

  • For any column, you can change the association of a result set by clicking the Result Set Browser button to display the Select Result Set dialog, selecting the required result set, then clicking the Select button.

  1. Click the Update button to finish and return to the template.




More Information:

Adding Formula Columns on page 132



    1. Share with your friends:
1   ...   54   55   56   57   58   59   60   61   ...   209


The database is protected by copyright ©dentisty.org 2019
send message

    Main page