Products
Admissions & Enrollment
After School Activities
API
Cafeteria & POS
School CRM
Data Analytics & AI
CMS
Donations
Enrollment Management System
Financial Aid Management
Finance & Accounting
Fundraising
Point of Sale
Scheduling
Student Information System
Summer School & Summer Camp
Solutions
K-12 Private and Independent Schools
K-12 Public Schools
Colleges & Universities
Medical Schools
Vocational and Technical Schools
International Schools
Dance and Theater Schools
Youth Programs
Why PCR Educator
Team
Knowledge Base
FAQ
Training and Support
PCR independent school management solution and website
Products
Admissions & Enrollment
After School Activities
API
Cafeteria & POS
School CRM
Data Analytics & AI
CMS
Donations
Enrollment Management System
Financial Aid Management
Finance & Accounting
Fundraising
Point of Sale
Scheduling
Student Information System
Summer School & Summer Camp
Solutions
K-12 Private and Independent Schools
K-12 Public Schools
Colleges & Universities
Medical Schools
Vocational and Technical Schools
International Schools
Dance and Theater Schools
Youth Programs
Why PCR Educator
Team
Knowledge Base
FAQ
Training and Support
Sign In
Demo
School CRM
Blog
DAT Fields - Step 2 - Adding Calculated Field
DAT Fields - Step 2 - Adding Calculated Field
DAT Fields - Step 2 - Adding Calculated Field
Calculated fields are dynamic formula-based fields added to a
DAT Query
in
DAT
FIelds - Step 2.
To add a new calculated field:
- Identify the numerical or character fields and their corresponding variable names listed in the first column of the grid.
Note
: You cannot mix character and numeric fields in a calculated field.
Note
: Even if the character field has numeric data, it is only eligible for character fields.
Example
: The student Alternate Id field is a character field. Even if you have numbers in this field, it is still only eligible for a character calculated field.
- Specify the desired formula below the grid using the variable names identified in the previous step.
Example
: A / 100
Example
: A * B
Example
: B +', ‘ + A
- Click “Add Calculated Field”
Note
: Calculated fields can be constructed from other calculated fields.
Note
: For numeric fields, the type of number shown is determined by the type of numbers involved in the formula. If only integer numbers are used, the result will be an integer number. If a decimal number is used at any point, then the result will be a decimal number.
Example
: Suppose A represents an integer column. A / 100 will result in an integer value. If the value for A is less than 100, the result will be 0.
Example
: Suppose A represents an integer column. A / 100.0 will result in a value with decimals because the divisor is a decimal.
Note
: The following characters may be used to create numeric calculated fields:
( )
Parenthesis controlling the order of mathematical operations.
Note
: Opening and closing parenthesis must match.
+
Addition
-
Subtraction
*
Multiplication
/
Division
A-ZZ
Variable names corresponding to an existing field.
Note
: A calculated field may not be added if the resulting number is too large, too small, or results in an invalid mathematical result.
Example
: Division by 0.
Note
: The following characters may be used to create character calculated fields:
( )
Optional. Parenthesis control the order of operations.
Note
: Opening and closing parenthesis must match.
Note
: Parenthesis are permitted but unnecessary for character calculated fields.
+
Concatenate characters or fields
'
Use single quotes (apostrophes) to designate characters included in the calculated field.
Example
: 'First: ‘ + A + ‘ Last: ‘ + B
Note
: Apostrophes must always appear in pairs.
Note
: Currently, it is not possible to include an apostrophe as a character in the calculated field.
A-ZZ
Variable names corresponding to an existing field.
See also
DAT Fields - Step 2
DAT Query
Action
DAT
Linkedin
301-947-7380
sales@pcreducator.com
Schedule Demo
Please, make sure that all required fields (marked with *) are completed.
School Name
*
Relation to School
*
select
Administration - Database Manager
Administration - Head of School
Administration - Registrar
Development - Director of Development
Finance - Business Manager
Finance - CFO
IT - Director of Technology
Other - Parent
Other - Staff
Other - Volunteer
Last Name
*
Your First Name
*
Your Email
*
Your Phone #
*
Household
User
PCR Educator School Information System is an online database engineered for schools and universities to deliver the highest level of flexibility, unique experience, transparent communication and customized design.