Calculated fields Interview Questions and Answers-Workday
The Aggregate Related Instances calculated field lists all the instances associated with a field in a child object and eliminates any duplicate instances from the results. This field also enables you to apply a condition rule to filter the results based on criteria that you specify.
The Arithmetic Calculation Calculated Field performs simple Arithmetic operations like addition, Subtraction, Multiplication and division.
The Build Date calculated field enables you to create a new date field by mixing and matching date (or date-time) components from other fields or from specified values.
The Concatenate Text function concatenates a series of text fields.
The Convert Currency calculated field determines the equivalent value of a field in a different currency and can vary from instance to instance for the same field, depending on the functional area in which it is used. For example, you can record a one-time bonus amount in an employee’s local currency which, in a global environment, could vary from employee to employee. With the Convert Currency calculated field, you can specify the source currency field and target currency, converting the one-time bonus amount to a common currency.
This calculated field enables you to convert a number that currently exists as a text field to a numeric data type. For example you can extract the year from a text field, giving you 2014. This is required to perform calculations on the year.
The Count Related Instances calculated field dynamically counts instances of a related business object based on a test condition defined for the related business object. For example, it can compute the span of control by counting the number of managers in an organization, or the cost-per-hire per location by counting the number of employees hired during the last year.
This function creates a date, date/time, or date/time/time zone constant for use in other calculations.
The Date Difference function computes the number of days, months, or years between two dates. The start date is subtracted from the end date.
This calculated field groups and transforms data by evaluating a series of Boolean test conditions. Workday applies the default value and then starts testing conditions starting with the first condition defined. Once it finds a condition that is true, Workday returns the corresponding value and does not test any subsequent conditions.
Python is a dynamic interrupted language which is used in wide varieties of applications. It is very interactive object oriented and high-level programming language.
Tableau is a Software company that caters interactive data visualization products that provide Business Intelligence services. The company’s Head Quarters is in Seattle, USA.
Micro Strategy is one of the few independent and publicly trading Business Intelligence software provider in the market. The firm is operational in 27 Countries around the globe.
Pega Systems Inc. is a Cambridge, Massachusetts based Software Company. It is known for developing software for Customer Relationship Management (CRM) and Business process Management (BPM).
Workday specialises in providing Human Capital Management, Financial Management and payroll in online domain.It is a major web based ERP software vendor.
Power BI is business analytics service by Microsoft. With Power BI, end users can develop reports and dashboards without depending on IT staff or Database Administrator.