Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'm trying to get the previous value in a straight table.
Basically here is the table example:
Period | Value | Expected value | |
Jan-12 | 100 | ||
Feb-12 | 200 | 100 | Value of January |
Mar-12 | 300 | 200 | |
Apr-12 | 400 | 300 | |
May-12 | 200 | 400 | |
Jun-12 | 100 | 200 | |
Jul-12 | 100 | 100 | |
Aug-12 | 90 | 100 |
I wanted to do it in the chart expression. Attached it is the QV as example
I have tried already the Before function, without sucess.
So, if somebody could help I really appreciate.
Thanks in advance, Leandro
Hi,
Try above([ValueCurrent])
Have a look at the attachment.
Regards,
Kaushik Solanki
Hi,
Try above([ValueCurrent])
Have a look at the attachment.
Regards,
Kaushik Solanki
Hi,
You can use Above(), to get the value of previous row in a straight table.
Regards,
Jagan.