Impromptu 7.3 Retrieve value from the previous row.

[L34621]

In Impromptu 7.3, Is there a function or technique which would fill in a blank field with data from a previous record? I have not been successful with if-then-else statements, the data must come from the previous record.

Any help is much appreciated.... Thanks! Donna

 

[L34621]

Well, I guess never mind...I was able to fill in the missing data by creating a running count field and then create Minimum date field by the new running count.

It works! But I think a lag function in Imporomptu would have been so much easier.

Take Care! ...Donna