PCR independent school management solution and website
Customer Portal
School Portal
Request Demo
SOLUTION
FAQ
PRICING
EMPLOYMENT
BLOG
SUPPORT
KNOWLEDGE BASE
Admissions
CMS Website
Community Connect
Finance & Student Billing
Fundraising / Development
Student Information
Cafeteria POS
Summer Camp & School
301-947-7380
sales@pcreducator.com
School Information Management System & Website Software
Blog
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 fields and their corresponding variable names listed in the first column of the grid.
- Specify the desired formula below the grid using the variable names identified in the previous step.
Example
: A / 100
Example
: A * B
- Click “Add Calculated Field”
Note
: Calculated fields can be constructed from other calculated fields.
Note
: 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 calculated fields:
( )
Parenthesis controlling the order of mathematical operations.
Note
: Opening and closing parenthesis must match.
+
Addition
-
Subtraction
*
Multiplication
/
Division
A-Z
Variable names corresponding to an existing numeric 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.
See also
DAT Fields - Step 2
DAT Query
Action
DAT
PCR Educator K-12 School Information System is an online database engineered for independent and private schools to deliver the highest level of flexibility, unique experience, transparent communication and customized design. Being a complete cloud-based solution, PCR Educator system guarantees convenient access anytime, anywhere.
Facebook
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 - CFO
Finance - Business Manager
IT - Director of Technology
Other - Parent
Other - Staff
Other - Volunteer
Last Name
*
Your First Name
*
Your Email
*
Your Phone #
*
Household
User