repeat value until new match in script

[pepe2209]

Hello

I would like to achieve the following: now my table looks like this:

Date	StartDate	Value	Startvalue
16-01-2014	14-01-2014	5	3
15-01-2014	14-01-2014	4	3
14-01-2014	14-01-2014	3	3
13-01-2014	10-01-2014	20	17
12-01-2014	10-01-2014	19	17
11-01-2014	10-01-2014	18	17
10-01-2014	10-01-2014	17	17

I want to create the right column (Startvalue) in the script.

So when the startdate matches the date, the value recorded is the startvalue:

if(Date=StartDate, Value) as Startvalue.

But then this startvalue needs to be repeated for each following date until a new startdate matches the date.

How can i achieve this?

Your help would be much appreciated

regards,

Peter

[hic · Accepted solution]

if(Date=StartDate, Value, Peek(PropagatedValue)) as PropagatedValue

HIC

[pepe2209]

Ok thanks, so that was rather easy