6 Replies Latest reply: May 15, 2014 10:09 AM by gewern _ RSS

    Need help with a calculated field

    gewern _

      I have been able to successfully capture all my report data into a table window. I need some guidance on one part of the table. 

       

      My report data looks like this:

      SEQ     Date

      1     10/01/2010

      2     10/01/2010

      3     10/01/2010

      4     10/01/2010

      5     -


      6     10/04/2010

      7     10/04/2010

      8     10/04/2010

      9     10/04/2010

      10     10/04/2010

      11     -


       

      This data pattern repeats for each company.  When there is no date I would like to populate the table with the value above.  In excel, it's easy. I would write an IF statement and replace with cell above.  I don't see a way to reference the prior date value in the table cell above in a calculated field. Can someone advise?

      Thanks.

      GW