How to get previous row value in to present row

[Gopi_E]

Hi All,

I have fields Date and Value  like bellow 

Here I want output like this

Thanks in advance

Gopi

[tresesco]

In chart or script?

[tresesco · Accepted solution]

In script, try like:

If(Value>0, Value, Peek(NewValue)) as NewValue

[Gopi_E]

Hi  Tresco,

Thanks for reply

in edit script, I tried by using the previous function but it will give a result for only one row. 

script or chart no problem please give any idea about this

[Gopi_E]

Hi,

It works perfectly in edit script.

can I able to get same result in the chart 

[tresesco · Accepted solution]

You can. Create a new expression (label: NewValue) and then expression:

If(Value>0, Value, Above(TOTAL NewValue))

[Gopi_E]

Thanks for spending your time for me.

it works perfectly. 

here I missed Total Qualifier

Thanks,

Gopi