Right now, Nth returns an error if the provided index is not found. E.g. if my table has three rows, and I write the formula: [My Table].Nth(5) I will get this result: [image] However, if I’m trying to write a running total with Nth I could approach it like: thisTable.Nth(thisTable.Find(thisRo…

You might want to look at this topic: [image] Referencing the cell above Tips and Hacks Sometimes you need to implement iterative calculation where a value in the next row depends on the value in the previous row (e.g., interest calculator). To do this in Excel / Sheets, …

Yeah, I know how to do a running total with thisRow.RowId() but I want to do it with Nth, that’s why I’m asking if there is a way to get Nth to return blank (not error) if it fails a lookup.

I’ve been making a doc with that, here: (you’re probably going to want to hide the rowid column., also, you should use a sort.) I hope this helps!

Dear @BODHI_SCHNEIDER , Thanks sharing a sample, would you mind to update the sharing setting to " everybody with the link", to become visible to the community? Always eager to learn :wink:

Sure @Jean_Pierre_Traets ! :grinning_face_with_smiling_eyes: Just PLEASE don’t delete anything, I couldn’t find play so I put it on edit.

[image] BODHI_SCHNEIDER: Just PLEASE don’t delete anything, I couldn’t find play so I put it on edit. The play mode is in the Embed option :wink: [Capture d’écran 2020-12-29 à 18.55.49] So far, my Test docs are still in “can view” :blush: . [Capture d’écran 2020-12-29 à 18.58.13]

Hi Connor, why would the index ever be out of range if you are finding thisRow in thisTable? Except for the first row, I suppose, which has no previous. But maybe this is what you are looking for? But you are right, it is not as elegant as Nth() returning a blank value rather than an error. With…

Yeah, this specific lookup is likely not more efficient. When I’m back at my computer I’ll have to look back at what I thought would be more efficient. Yes, an if statement solves the problem at the price of elegance.

So apparently it is working now. In my memory, this formula brought up an error before, and now it still has an error but continues the calculation. thisRow.Amount+thisTable.Nth(Find(thisRow,thisTable)-1).[Running Total] The inelegant if statement is gone :slight_smile: (Updated my doc above.) S…

[image] Ryan_Martens1: thisRow.Amount+thisTable.Nth(Find(thisRow,thisTable)-1).[Running Total] For my understanding, The Running Total is the delta between N and N+1 ? if that is the case an alternative might be: thisTable.[Running Total].Slice(1,Find(thisRow,thisTable)).Sum()` best, Chris…

How to get `Nth` to return `Blank` if index is not found

Pch December 29, 2020, 6:01pm 12

The play mode is in the Embed option

So far, my Test docs are still in “can view” .

No help needed - Just a question to ask about : Concatenate() a list of sequential and/or non-sequential numbers?

Topic		Replies	Views
Referencing the cell above Tips and Hacks	43	23089	November 4, 2023
😬 What was hard for you to discover in Coda?	40	7339	October 14, 2021
How do i end my row with sum off all previous columns?	18	4341	March 5, 2022
Visual Position of the row in table Tips and Hacks	33	11982	June 26, 2023
RIGHT() formula help and already exists?	23	3065	May 26, 2019

How to get `Nth` to return `Blank` if index is not found

Related topics