Which of the following rules is the more efficient or in the following case is there no real material difference? :
Code: Select all
['Forecast', 'Annual Revenue'] = N:
(DB('Revenue', !Version, !Period, !Dept , 'Total Revenue')
+ DB('Revenue', !Version, ATTRS('Period', !Period, 'Period n-1'), !Dept, 'Total Revenue')
+ DB('Revenue', !Version, ATTRS('Period', !Period, 'Period n-2'), !Dept, 'Total Revenue'))
* 4;
Code: Select all
['Forecast', 'Annual Revenue'] = N:
DB('Revenue',!Version, !Period | 'Previous', !Dept, 'Total Revenue') *4;
Maren