Create Dynamic Time References in Formulas

Question

I need to write a formula that functions like this:

ACCT.IT_Expense[time=01/2017]

except instead of 2017, I 'd like to reference January of which ever year being reported on. How can I write the time modifier to function this way?

Answer

With current functionality, there is not a syntax to dynamically reference the first month of the current year. For example, you cannot write a formula that says,

ACCT.IT_Expense[time=1/this.year]

. However, you can get similar results using an if statement. Your formula would look something like: