TM1 Forum

Hi

I am new to TM1 and can't figure out how to dynamically lookup prior year figures. This rule works great "['Prior Year Actual']=N: ['June 2014 YTD','Actual'];", but if I want to look at anything other than FY 2015, its not so good. Is there a way to make 2014 in my code dynamic based upon to FY that is in context?

Thanks

Just put the prior year as an attribute in your period dimension and reference that in a DB formula.

I think I had tried everything but that. Thanks!