Reference previous value in straight table

[Dayna]

Hi All,

I know of Peek() and Previous() in the script, but can you use similar functionality in charts and tables?

i.e. I want to use a previous value in a table, but this value is created from different sources and can't be done in the script, the end result should look like this:

Date	Value	Combined (Value + Previous Combined)
01/01/2018	100	100
02/01/2018	100	200
03/01/2018	50	250
04/01/2018	60	310
...

The idea is, that I can then do an average of this value, but always including the value from the row before.

Previous seems right, but I gather this is only for script and based on ordered data. Any suggestions you can offer would be appreciated.

Kind Regards,

Dayna

[sunny_talwar · Accepted solution]

You can use Missing Manual - Above() and Below()

For your specific question, you cna try like this

RangeSum(Above(Sum(Value), 0, RowNo()))

Also, look here

Calculating rolling n-period totals, averages or other aggregations

[niclaz79]

Hi,

As described above the Above and Below functions do the same as Previous and Peek.

Worth to mention is if you have a pivot with some dimensions as columns, you use the Before and After functions instead to move left or right in the table.

[Dayna]

Thanks all!!