メインコンテンツまでスキップ
Adaptive Insights
Knowledge @ Adaptive Insights LLC, a Workday Company

Formula Examples: Dynamic Time Reference

Describes a workaround for referencing the same month across multiple years.

To reference a particular month in the current year, you cannot use syntax like this in a formula:

 [time=month_number/this.year]

But, you can use an if or iff statement to accomplish similar results. For example, to reference the month of January (month = 01) in a series of successive years, use the following:

iff(year(this)=2017,ACCT.IT_Expense[time=01/2017],iff(year(this)=2018,ACCT.IT_Expense[time=01/2018],iff(year(this)=2019,ACCT.IT_Expense[time=01/2019]...

 

  • この記事は役に立ちましたか?