and Previous Rows

Daily Measurements

  • I wanted to see how this day related to the previous day
  • I needed a column that helped me to define my long term targets. Thus how many kilos in how many days or months to get some realistic numbers.

Previous day

step 01 :thisTable.[Targets in Kg].Nth(Find(thisRow,thisTable )-1)
step 02: thisRow.[Targets in Kg] - thisTable.[Targets in Kg].Nth(Find(thisRow,thisTable )-1)
PreviousRow Logic Applied
appling an If statement to start with an empty cell in case it is the first one
The importance of working with lists
DeltaSum Explained

The DeltaSum


In short

Huizer Automation on how to apply a PreviousRow logic in



Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store