I have following rules to calculate previous and next year values:
Code: Select all
['Revenues','Last Year']=N:DB('Cube',ATTRS('Year',!Year,'Prev'),'This Year');
['Revenues','Next Year']=N:DB('Cube',ATTRS('Year',!Year,'Next'),'This Year');
Thanks,
Vladino
EDIT:
Solved, DB functions were missing all dimensions...
