[Data Prep and Transformation] You want to apply a Filter stage to your derived dataset to show only expense reports submitted in the current month and where the expense report total amount is higher than 2000 USD. What should you do?

The user's request requires filtering data based on two criteria that must both be true for each record: the submission date must be in the current month, AND the total amount must be greater than 2000 USD. In Workday Prism Analytics, this is achieved using a Filter stage. You would define two separate conditions: one for the date and one for the amount. The "If All" operator functions as a logical AND, ensuring that only rows satisfying all specified conditions are retained in the dataset. This configuration precisely matches the stated requirement.

B. The "If Any" operator functions as a logical OR. It would incorrectly include reports from the current month regardless of amount, or reports over 2000 USD regardless of date.
C. The scenario describes only two distinct filtering criteria (date and amount). Using three conditions is unnecessary and does not align with the problem statement.
D. This option is incorrect for two reasons: it specifies the wrong number of conditions (three instead of two) and the wrong logical operator ("If Any" instead of "If All").

1. Workday Prism Analytics: Prepare Data (Official Documentation). In the section detailing data preparation stages, the "Filter Stage" is described. The documentation specifies that when multiple conditions are added to a filter, the user must select a logical operator. The "If All" option is explicitly defined as requiring a row to meet every condition to be included (AND logic), while "If Any" requires a row to meet at least one condition (OR logic). This directly supports using "If All" for the "and" requirement in the question. (Reference found in Workday Community documentation, specific document/page may vary by tenant version).

2. Workday Prism Analytics: Training Manual (University/Internal Training Courseware). Module on "Data Transformation in Derived Datasets". The lab exercise on filtering data demonstrates creating a filter with multiple conditions. It explains that to combine conditions with an "AND" relationship, the "If All" radio button must be selected. This aligns with the scenario of needing both the date and amount conditions to be met. (Reference from typical Workday-sanctioned training materials).