Valid Workday-Adaptive-Planning Dumps shared by ExamDiscuss.com for Helping Passing Workday-Adaptive-Planning Exam! ExamDiscuss.com now offer the newest Workday-Adaptive-Planning exam dumps, the ExamDiscuss.com Workday-Adaptive-Planning exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com Workday-Adaptive-Planning dumps with Test Engine here:
Your Adaptive Planning instance uses the default time stratum. You are creating a monthly formula that should be an average of the quarter from one year ago. How do you write the formula?
Correct Answer: A
In Workday Adaptive Planning, the default time stratum is Month > Quarter > Year. To reference the same quarter from one year ago, the correct time modifier is [time=this.qtr-4], which shifts back four quarters (equivalent to one year) from the current quarter. The divf() function performs a floating-point division of the quarterly total by 3 to derive a monthly average. This is correct because a quarter contains 3 months, and dividing the quarterly amount by 3 yields the average monthly value for that quarter. The formula divf(ACCT.Example[time=this.qtr-4], 3) retrieves the total value for the quarter that is four quarters prior and divides by 3 to return the average monthly value. Option B uses this.year-1, which references the full prior year rather than the same quarter. Option C's syntax [time=this.qtr, this.year-1] is not valid Adaptive Planning formula syntax. Option D uses a month range modifier that does not correctly target a full quarter. Reference: Workday Adaptive Planning - Time Modifiers, Quarter Reference, divf() Function, Formula Syntax.