6 Replies Latest reply: Aug 10, 2016 10:08 AM by Vishwarath Nagaraju RSS

    Jan 2016 close stock amt is eqal to Feb 2016 Open stock , Feb 2016 close stock amt is eqal to Mar 2016 Open stock. I have Jan 2016 Close stock amt , how to make Feb 2016 display as open stock ?

    PAUL YEO

      Hi All

       

       

      I have Table 1 exprssion from Mr sunny , display close stock amount in Table 1 :-

       

       

      (

      money(

      (RangeSum(Above(RangeSum

      (Above(

      Sum

      (

      {

      <

      year, month, sTOCK={sTOCK}

      >

      }

      [Amount]*1)/Rate, 0, RowNo()))),

      -

      Sum(

      {

      <

      sTOCK={sTOCK}>

      }

      TOTAL Aggr(Sum(

      {

      <

      year, month, sTOCK={sTOCK}

      >

      }

      [Amount]*1)/Rate, YearMonth

      ))))

      , $(vMoneyFormatK))

      )

       

       

       

       

      Table 1

      yearMonth CLOSED STOCK AMT

       

       

      2016 JULY 1,521,449

      2016 JUNE 1,558,736

      2016 MAY 1,505,156

      2016 APR 1,422,434

      2016 MAR 1,452,717

      2016 FEB 1,413,910

      2016 JAN 1,206,673

       

       

      May i know how to get the open stock amount as below :-

       

      yearMonth OPEN STOCK AMT

       

       

      2016 JULY 1,558,736

      2016 JUNE 1,505,156

      2016 MAY 1,422,434

      2016 APR 1,452,717

      2016 MAR 1,413,910

      2016 FEB 1,206,673

       

       

      Remark :-

      Jan 2016 close stock amt is eqal to Feb 2016 Open stock

      Feb 2016 close stock amt is eqal to Mar 2016 Open stock

       

       

      Hope some one can help me modify the expression , So tht i can have additional column display Open stock amount at Table 1.

       

       

      Paul