Skip to content
Template: Canvas - thisRow
Share
Explore

icon picker
Canvas - thisRow

step by step to make things simple
In the table 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:

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.