Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Workday-Adaptive-Planning Exam - Topic 4 Question 6 Discussion

The financial analyst is updating the formula for the Office Supplies account and needs to incorporate the full year office supplies expenses from the previous fiscal year. What formula should the analyst implement to retrieve last year's value?
B) ACCT.OfficeSupplies[time=this.year-1]
A) ACCT.OfficeSupplies[time=last.year]
C) ACCT.OfficeSupplies[year=previous]
D) ACCT.OfficeSupplies[time=this-12]

Workday-Adaptive-Planning Exam - Topic 4 Question 6 Discussion

Actual exam question for Workday's Workday-Adaptive-Planning exam
Question #: 6
Topic #: 4
[All Workday-Adaptive-Planning Questions]

The financial analyst is updating the formula for the Office Supplies account and needs to incorporate the full year office supplies expenses from the previous fiscal year. What formula should the analyst implement to retrieve last year's value?

Show Suggested Answer Hide Answer
Suggested Answer: B

In Workday Adaptive Planning formula syntax, [time=this.year-1] is the correct and officially supported modifier to retrieve the full prior fiscal year value of an account. This modifier navigates to the year period that is one year before the current year context, returning the annual total for the previous fiscal year --- which is the precise requirement for incorporating full-year prior year expenses into a formula. Option A uses [time=last.year], which is not standard Adaptive Planning formula syntax and would result in a formula error. Option C uses [year=previous], which is also not valid Adaptive Planning formula notation. Option D uses [time=this-12], which shifts back 12 months --- for a monthly formula, this returns the same month from the prior year, not the full prior year total. When a formula needs the full prior year annual amount (sum of all 12 prior months), [time=this.year-1] retrieves the aggregated annual value. This is the authoritative time modifier syntax for annual prior year references in Adaptive Planning. Reference: Workday Adaptive Planning --- Time Modifiers, Prior Year Reference, Formula Syntax Guide.


Contribute your Thoughts:

0/2000 characters
Buffy
2 hours ago
I’m leaning towards option B too, but what if the fiscal year doesn't align with the calendar year? That could complicate things.
upvoted 0 times
...
Nickolas
5 days ago
I practiced a question like this, and I feel like option A is too vague. It doesn't clearly indicate which year it's referencing.
upvoted 0 times
...
Fabiola
10 days ago
I'm not entirely sure, but I remember something about using "previous" in similar questions. Maybe option C could work?
upvoted 0 times
...
Domitila
16 days ago
I think option B makes sense since it specifies "this.year-1," which should correctly pull last year's data.
upvoted 0 times
...

Save Cancel