Skip to Content
0
Former Member
Jul 18, 2007 at 11:15 AM

Selection smallest year for NPV

20 Views

Hi *,

i am trying to create a Net Present Value function.

Therefor, I need the smallest year in my selection.

Does anybody know, how to get the smallest year in a selection.

e.g.: 2005, 2006, 2007 ....

So i need 2005 as basic year ... how can I select that ??

Here is a little code example from my function:

FOREACH S_FISCYEAR.
IF T_YEAR_FIRST >= T_YEAR_ACT.
      IF T_YEAR_ACT < T_YEAR_FIRST AND T_YEAR_ACT > T_YEAR_LAST.
         T_YEAR_FIRST = T_YEAR_ACT .
         S_AMOUNT = { 0AMOUNT, MY_FISCYEAR }.
      ENDIF.
ENDIF.


     T_YEAR_CALC = T_YEAR.

    IF T_YEAR_CALC >= 0.
     T_YEAR_CALC = T_YEAR_CALC + (FLOATYEAR - T_YEAR_SMALL).
   ENDIF.
ENDFOR.