JavaScript required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
Skip to content
Gallery
Template PreviousRow() in Coda
previousRow()
Rolling Total
DB Wood Sales
DB Wood
Moving average
DB Brussels - Paris
More
Share
Explore
DB Wood Sales
compound counting in the context of previous row
View of DB Wood Sales
Blog explaining the step you see below: ⤵️
previousRow() in Coda, a bad idea?
Why a button is your friend to track changes
huizer.medium.com
DB Wood Sales
DB Wood Sales
1
Name
rowIndex
wood
sold
cumul
initialStock
outcome
step01
step02
step03
step04
step05
outcomeRefined
turnover
Name
rowIndex
wood
sold
cumul
initialStock
outcome
step01
step02
step03
step04
step05
outcomeRefined
turnover
1
10 m3 Beech
1
Beech
10
10
410
400
10 m3 Beech
50 m3 Beech
[
10
]
[
50
]
[
10
]
[
10
50
]
10
10
400
$7,000.00
2
50 m3 Beech
2
Beech
50
60
410
350
10 m3 Beech
50 m3 Beech
[
10
]
[
50
]
[
10
]
[
10
50
]
10
50
60
350
$35,000.00
3
50 m3 Birch
1
Birch
50
10
934
924
50 m3 Birch
50 m3 Birch
[
50
]
[
50
]
[
50
]
[
50
50
]
50
50
884
$12,500.00
4
50 m3 Birch
2
Birch
50
60
934
874
50 m3 Birch
50 m3 Birch
[
50
]
[
50
]
[
50
]
[
50
50
]
50
50
100
834
$12,500.00
5
10 m3 Cherry
1
Cherry
10
10
155
145
10 m3 Cherry
50 m3 Cherry
70 m3 Cherry
[
10
]
[
50
]
[
70
]
[
10
]
[
10
70
]
[
10
70
50
]
10
10
145
$7,800.00
6
70 m3 Cherry
2
Cherry
70
60
155
95
10 m3 Cherry
50 m3 Cherry
70 m3 Cherry
[
10
]
[
50
]
[
70
]
[
10
]
[
10
70
]
[
10
70
50
]
10
70
80
75
$54,600.00
7
50 m3 Cherry
3
Cherry
50
110
155
45
10 m3 Cherry
50 m3 Cherry
70 m3 Cherry
[
10
]
[
50
]
[
70
]
[
10
]
[
10
70
]
[
10
70
50
]
10
70
50
130
25
$39,000.00
8
10 m3 Maple
1
Maple
10
10
773
763
10 m3 Maple
90 m3 Maple
[
10
]
[
90
]
[
10
]
[
10
90
]
10
10
763
$4,500.00
9
90 m3 Maple
2
Maple
90
60
773
713
10 m3 Maple
90 m3 Maple
[
10
]
[
90
]
[
10
]
[
10
90
]
10
90
100
673
$40,500.00
10
70 m3 Oak
1
Oak
70
10
947
937
50 m3 Oak
50 m3 Oak
70 m3 Oak
[
50
]
[
50
]
[
70
]
[
70
]
[
70
50
]
[
70
50
50
]
70
70
877
$53,200.00
11
50 m3 Oak
2
Oak
50
60
947
887
50 m3 Oak
50 m3 Oak
70 m3 Oak
[
50
]
[
50
]
[
70
]
[
70
]
[
70
50
]
[
70
50
50
]
70
50
120
827
$38,000.00
12
50 m3 Oak
3
Oak
50
110
947
837
50 m3 Oak
50 m3 Oak
70 m3 Oak
[
50
]
[
50
]
[
70
]
[
70
]
[
70
50
]
[
70
50
50
]
70
50
50
170
777
$38,000.00
13
50 m3 Padauk
1
Padauk
50
10
916
906
50 m3 Padauk
70 m3 Padauk
[
50
]
[
70
]
[
50
]
[
50
70
]
50
50
866
$36,250.00
14
70 m3 Padauk
2
Padauk
70
60
916
856
50 m3 Padauk
70 m3 Padauk
[
50
]
[
70
]
[
50
]
[
50
70
]
50
70
120
796
$50,750.00
15
90 m3 Sycamore
1
Sycamore
90
10
977
967
90 m3 Sycamore
[
90
]
[
90
]
90
90
887
$31,500.00
16
30 m3 Walnut.
1
Walnut.
30
10
421
411
30 m3 Walnut.
50 m3 Walnut.
[
30
]
[
50
]
[
30
]
[
30
50
]
30
30
391
$27,000.00
17
50 m3 Walnut.
2
Walnut.
50
60
421
361
30 m3 Walnut.
50 m3 Walnut.
[
30
]
[
50
]
[
30
]
[
30
50
]
30
50
80
341
$45,000.00
There are no rows in this table
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
Ctrl
P
) instead.