Skip to content
Template: Canvas - thisRow
Canvas - thisRow
More
Share
Explore

icon picker
Canvas - thisRow

step by step to make things simple
Christiaan Huizer
In the table
DB Turnover
⁠
you find:

[DB Turnover].Filter(month.Contains(thisRow.month)).turnOver.Sum()

Below how this one works on the canvas in steps, from easy to complex to simple and in this blog the details:

⁠
This link can't be embedded.
⁠
⁠

step 01

⁠
@1 - January
@1 - February
@1 - March
@1 - April
@1 - May
@1 - June
@1 - July
@1 - August
@1 - September
@1 - October
@1 - November
@1 - December
@2 - January
@2 - March
@2 - May
@2 - August
⁠
⁠

step 02

⁠
[
@1 - January
@1 - February
@1 - March
@1 - April
@1 - May
@1 - June
@1 - July
@1 - August
@1 - September
@1 - October
@1 - November
@1 - December
@2 - January
@2 - March
@2 - May
@2 - August
][
@1 - January
@1 - February
@1 - March
@1 - April
@1 - May
@1 - June
@1 - July
@1 - August
@1 - September
@1 - October
@1 - November
@1 - December
@2 - January
@2 - March
@2 - May
@2 - August
][
@1 - January
@1 - February
@1 - March
@1 - April
@1 - May
@1 - June
@1 - July
@1 - August
@1 - September
@1 - October
@1 - November
@1 - December
@2 - January
@2 - March
@2 - May
@2 - August
][
@1 - January
@1 - February
@1 - March
@1 - April
@1 - May
@1 - June
@1 - July
@1 - August
@1 - September
@1 - October
@1 - November
@1 - December
@2 - January
@2 - March
@2 - May
@2 - August
][
@1 - January
@1 - February
@1 - March
@1 - April
@1 - May
@1 - June
@1 - July
@1 - August
@1 - September
@1 - October
@1 - November
@1 - December
@2 - January
@2 - March
@2 - May
@2 - August
][
@1 - January
@1 - February
@1 - March
@1 - April
@1 - May
@1 - June
@1 - July
@1 - August
@1 - September
@1 - October
@1 - November
@1 - December
@2 - January
@2 - March
@2 - May
@2 - August
][
@1 - January
@1 - February
@1 - March
@1 - April
@1 - May
@1 - June
@1 - July
@1 - August
@1 - September
@1 - October
@1 - November
@1 - December
@2 - January
@2 - March
@2 - May
@2 - August
][
@1 - January
@1 - February
@1 - March
@1 - April
@1 - May
@1 - June
@1 - July
@1 - August
@1 - September
@1 - October
@1 - November
@1 - December
@2 - January
@2 - March
@2 - May
@2 - August
][
@1 - January
@1 - February
@1 - March
@1 - April
@1 - May
@1 - June
@1 - July
@1 - August
@1 - September
@1 - October
@1 - November
@1 - December
@2 - January
@2 - March
@2 - May
@2 - August
][
@1 - January
@1 - February
@1 - March
@1 - April
@1 - May
@1 - June
@1 - July
@1 - August
@1 - September
@1 - October
@1 - November
@1 - December
@2 - January
@2 - March
@2 - May
@2 - August
][
@1 - January
@1 - February
@1 - March
@1 - April
@1 - May
@1 - June
@1 - July
@1 - August
@1 - September
@1 - October
@1 - November
@1 - December
@2 - January
@2 - March
@2 - May
@2 - August
][
@1 - January
@1 - February
@1 - March
@1 - April
@1 - May
@1 - June
@1 - July
@1 - August
@1 - September
@1 - October
@1 - November
@1 - December
@2 - January
@2 - March
@2 - May
@2 - August
]
⁠
⁠

step03

⁠
[
@1 - January
@2 - January
][
@1 - February
][
@1 - March
@2 - March
][
@1 - April
][
@1 - May
@2 - May
][
@1 - June
][
@1 - July
][
@1 - August
@2 - August
][
@1 - September
][
@1 - October
][
@1 - November
][
@1 - December
]
⁠
⁠

Step04

⁠
[$1,000.00$2,000.00][$1,500.00][$2,000.00$3,000.00][$1,750.00][$1,600.00$4,000.00][$1,890.00][$1,756.00][$1,000.00$5,000.00][$2,300.00][$1,890.00][$2,000.00][$4,000.00]
⁠
⁠

Step 05

⁠
$3,000.00$1,500.00$5,000.00$1,750.00$5,600.00$1,890.00$1,756.00$6,000.00$2,300.00$1,890.00$2,000.00$4,000.00
⁠
⁠

Step06

⁠
000000000000
⁠
⁠
⁠
None
⁠
⁠

Step07

⁠
0
⁠
⁠

Step08 → hard coded

⁠
$3,000.00
⁠
⁠

[DB Turnover].Filter(month.Contains(January)).turnOver.Sum()
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.