Getting Started In This Chapter



Download 14.49 Mb.
Page58/209
Date conversion08.07.2018
Size14.49 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.

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




More Information:

Adding Formula Columns on page 132
1   ...   54   55   56   57   58   59   60   61   ...   209


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

    Main page