6 Replies Latest reply: Aug 5, 2014 11:30 AM by Ajay Krishnan Prabhakaran RSS

    How to fix problems with Peek in the script?

    Leandro Duarte

      Hi, I'm trying to use the peek function in the script. Basically I have one value in the first month and I want to populate this down.

       

      The issue peek function is having some aleatory issue and I cannot have this visible down.

       

      The expression is the following =

      if(isnull(DataPrice),  Peek (DataPrice), DataPrice) as PricePeek,

       

      ordered by Date

       

      Please see below the expected results:

      5-08-2014 11-48-05 AM.png

       

      The files with the script are enclosed.

       

      Thanks in advance, Leadro