Add a numeral to the value above

[Anonymous]

Hey,

how can I add to the value above in the same column an other value. It must be calculated in the layout.

So it have to look like this:

the value I will add is here as example 10

amount
0
10
20
30
40
50
60

I think it sounds very simply, but until now I haven't found a solution.

Thanks for any help!

Regards,

Alex

[kumarnatarajan]

Hi,

Try this one:

EX: Value + above(Value)

[Anonymous]

Hey,

no this doesn't work. 

This expression show me in the first line - and in the next everytime 20.

Regards,

Alex

[sushil353]

your statement is little bit confusing...

if you want to add numeral 10 to each row of expression then : amount+10.

if you want to add the below or above value to the current row then use above() and below() functions.

HTH

Sushil

[Vidit]

Hi,

you can try it on the scripting side using previous function.

Value + previous(Value)

Leo

[Anonymous]

Hi,

but when I use above() I only add two values out of another line....but I would add a number to the line below in the same column.

[sushil353]

please post the sample table and the desired output.

[sushil353 · Accepted solution]

Please find the attached image..

HTH

Sushil

[Anonymous]

Hi,

here you have the output I will have. But this is made in the script, and I need it in the layout (in the table).

regards,

Alex

[Anonymous]

Hi,

I got it!!!

Thanks very much!!

regards,

Alex