Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Enable referencing second last row in formulas #334

Open
StegSchreck opened this issue Jun 11, 2024 · 1 comment
Open

Enable referencing second last row in formulas #334

StegSchreck opened this issue Jun 11, 2024 · 1 comment
Labels
enhancement New feature or request needs-review A newly created issue that has not yet been processed

Comments

@StegSchreck
Copy link

StegSchreck commented Jun 11, 2024

Is your feature request related to a problem? Please describe.
I want to have multiple rows filled via formulas. The second to last row should have some computed values (e.g. a sum of all values in that column above) and the last row should have values based on that.

Describe the solution you'd like
I want to be able to use @-1 or @>-1 as a reference for the target of a formula as well as an input for another formula.
e.g.

<!-- TBLFM: @>-1$4=sum(@I..@-2) -->   # sum of the column
...
<!-- TBLFM: @>$4=((@>-1$3 - @>-1$4) / 2) -->   # derived value based on the previously calculated ones

Describe alternatives you've considered
Only alternative I have found: have lots of empty columns just for calculating a few values.

@StegSchreck StegSchreck added enhancement New feature or request needs-review A newly created issue that has not yet been processed labels Jun 11, 2024
@SoCoLDuk
Copy link

SoCoLDuk commented Jul 1, 2024

Hi! Have you been able to find a solution to how to get a ref to the second last row in formulas?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request needs-review A newly created issue that has not yet been processed
Projects
None yet
Development

No branches or pull requests

2 participants