| A | |
| 1 |
 =file@s("quartersale.txt").import@t()
|
| 2 |
=A1.derive('Link-relative','Year-on-year')
|
| 3 |
=A2.sort(Year,Quarter)
|
| 4 |
>A3.run('Link-relative'=if(#==1,0,round((Amount-Amount[-1])/Amount[-1],4)))
|
| 5 |
=A3.group(Year)
|
| 6 |
>A5.(~.run('Year-on-year'=if(A5.#==1,0,round((Amount-A5[-1](#).Amount)/A5[-1](#).Amount,4))))
|
可以从A3中查看运算后的结果如下:
注意，计算中使用了包含符号的字段名，如Link-relative在引用字段时需要用单引号括起来。