Join the discussion
Question 2/22
You have a Personnel sheet that calculates a cell phone allowance paid each month unless an employee has earned over a certain salary threshold for the year. What is an accurate logic expression for the IF statement?
Correct Answer: C
The business rule states that the cell phone allowance is paid each month unless an employee has earned over a certain salary threshold for the year. This requires a year-to-date cumulative check - the system must compare the employee's cumulative salary earned to date against the annual threshold to determine if they have crossed it in any given month. The correct expression ROW.CumulativeSalary < ASSUM.CellThreshold compares the running cumulative salary (year-to-date earnings) against the threshold assumption. If cumulative salary is below the threshold, the allowance is paid; once it exceeds the threshold, the allowance stops. ROW.Salary compared to divf(ASSUM.CellThreshold,12) compares a monthly amount to a monthly portion of the threshold, which does not reflect cumulative earnings. ROW.Salary[time=last.year] references prior year data, not the current year accumulation. ROW.MonthlySalary compared to the annual threshold would only fire when a single month's salary exceeds the full-year threshold, which is incorrect logic. Reference: Workday Adaptive Planning - Personnel Sheet Formulas, IF Statements, Cumulative Functions.
Add Comments
- Other Question (22q)
- Q1. If you need to create a new user in the system, what do you select from the Global Navigat...
- Q2. You have a Personnel sheet that calculates a cell phone allowance paid each month unless a...
- Q3. How do you set up a task so that it is associated with a particular version and level?...
- Q4. The planner needs to display the profit margin ratio on the Income Statement, calculated a...
- Q5. Which two exchange rate types does a new Adaptive Planning instance create by default?...
- Q6. What is a properly formatted level name?
- Q7. An OPEX model uses headcount data linked from a personnel sheet. When testing with sample ...
- Q8. Scenario: A financial planner is responsible for ensuring the accuracy and structure of th...
- Q9. The planning team decided that no user should be able to edit the Office Supplies general ...
- Q10. You created a matrix report but forgot to include the version. What will happen?...
- Q11. Which element is required to create a modeled sheet?...
- Q12. A rollup account called Total Operating Expenses aggregates the balance of the child accou...
- Q13. Within a modeled sheet where users can select from different Benefit Elections stored as d...
- Q14. How do you navigate from the Welcome page to the Assumption accounts configuration page?...
- Q15. An administrator needs to add prior and future years to the existing calendar without affe...
- Q16. A financial plan requires an estimate for the Consulting Expenses account using the averag...
- Q17. You are building a Headcount cube sheet for a manufacturing company. Plant managers input ...
- Q18. Scenario: A financial planner is conducting a comprehensive audit of the income statement ...
- Q19. You need to structure a model to support both planning and reporting of expenses by projec...
- Q20. When setting up multiple currencies, what type of currency should you choose to enable as ...
- Q21. What task must you do before changing the default time stratum?...
- Q22. How many top level hierarchy structures can you have in an Adaptive Planning instance?...
[×]
Download PDF File
Enter your email address to download Workday.Workday-Adaptive-Planning.v2026-10-31.q22.pdf
