Hi there !
I’m very new to Coda and have been having a lot of fun with it for the past few weeks now
(I really really like it !)
But I’m currently completely stuck with one of my tables where I’m trying to get a cumulative result
This is a screenshot of a “Test” table I’ve created
What I’m trying to get in the
[Results] column is a cumulative
Sum() of the column
N2 but only with the numbers in
N2 between the
N1=0 (which is the row
Test1 here) and
N3=0 (the row
Test4) and then the
Sum() continues with the next
Is it possible ?
(I don’t mind complex solutions as I love to learn )
In my now-messy-non-test-table, those 2 specific values :
N1= 0 and
N3= 0 are landmarks I can count on along with the date & time in
column 7 (which I forgot to rename before taking the screenshot )
I’ve searched a lot here for a solution but wasn’t able to find one or, possibly, to apply it to my table
If someone has a solution, I’m all ears !