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 @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

⁠

step 02

⁠

[@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][@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][@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][@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][@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][@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][@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][@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][@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][@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][@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][@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]

⁠

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.