7 Replies Latest reply: Aug 23, 2013 9:39 AM by Celambarasan Adhimulam RSS

    Previous Function Help

      Hi! , I have this problem ... in the next table i would like to fill the Store field with the Previous Store value since I found a new value...

       

      StoreAmount
      A100

      200

      400
      B50

      100

      70

       

      I try the expression

       

      if(isnull(Store)=0,Store,Previous(Store))as [Store 2],

       

      but I only works for the next register not for all, I get something like this...

       

      Store2Amount
      A100
      A200

      400
      B50
      B100

      70

       

       

      Any ideas? , hope you can help me , Thanks in advance!