Calculated Fields (New)

Question 1

Evaluate and categorize the number of days off that an employee has taken over the past year - which CF function should you use?

Answer 1

Lookup Range Band

Question 2

Create a name field containing employees first and last name and preferred name - which CF function should you use?

Answer 2

Concatenate Text

Question 3

Count the number of sick days for employees on Tue, Wed, Thu - which CF function should you use?

Answer 3

Count Related Instances

Question 4

Return the number of days remaining before an employee returns from PTO - which CF function should you use?

Answer 4

Date Difference

Question 5

Group and return employee’s employee status (active, terminated, etc.)

Group and return employee’s age (under 30, 30-40(

Answer 5

Evaluate Expression
(uses Boolean)

Question 6

List the training each employee has completed over the last 12 months

Answer 6

Extract Multi-Instance

Question 7

Determine where a worker’s total compensation falls into and define label (high, low, medium - which CF function to use?

Answer 7

Lookup Range Band

Question 8

Include a manager’s email address when reporting on employee’s

Answer 8

Lookup related value
(must have 1:1 relationship)

Question 9

Lookup Value as of Date

Answer 9

Change detection

Question 10

The outline structure consists of what?

Answer 10

Primary hierachy and the expansion hierachies grid.

Question 11

How can you identify each outline structure?

Answer 11

you can define each outline structure by a required title and optional description.

Question 12

What do you use for the primary hiearchy?

Answer 12

Any business object.
Once you select it, the remaining fields within the primary hierarchy populate, but you can override them.

Question 13

what is the functionality of nesting within outlining?

Answer 13

Nesting allows you to drill down to lower hierarchies that may consist of ledger accounts or categories

Question 14

where do you define outline structures for control field columns?

Answer 14

In the Outline Data section. The default Outline Data checkbox defaults the outline structure on your row configuration

Question 15

Does the hierarchy structure initially expand for outline structures?

Answer 15

No.
You can set the Expand on Initial Display option to once or twice to determine the level to which you would like the structure to initially expand.

Question 16

where do you define the outline structure within a row?

Answer 16

Within the Outline Options section.
Use the Expansion level option to specify the primary hierarchy level that displays when you initially expand an outline