Visokio website     Downloads     Video tutorials     KnowledgeBase  
Formula in DataManager for Lag or Lead or Previous_Value ? - Visokio Forums
Formula in DataManager for Lag or Lead or Previous_Value ?
  • joemako May 1, 2012 5:44PM
    Does the DataManager have the ability to create a formula that returns the value of a field from the previous record?

    for example, in a data set like:

    ID,Value
    1,10
    2,20
    3,30

    I would like to get the result set:

    ID,Value,Previous_Value
    1,10,
    2,20,10
    3,30,20
  • 2 Comments
  •     chris May 1, 2012 6:04PM
    Hi,

    Try using the formula:

    SUBSET_SINGLETON([Value], ROWINDEXSUBSET(CURRENTROW()-1, "="))
  • joemako May 1, 2012 7:07PM
    Awesome! Thank you

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership