emacs-orgmode
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [O] Referring to the Last Row of a Remote Table using @>


From: Sankalp
Subject: Re: [O] Referring to the Last Row of a Remote Table using @>
Date: Fri, 13 Jan 2012 08:55:26 +0530

Hi,
Just saw this : http://thread.gmane.org/gmane.emacs.orgmode/50991

Apologies for initiating a new thread when the issue was already being discussed.

Sincerely,
-------
Sankalp


On 13 January 2012 07:47, Sankalp <address@hidden> wrote:
Here's a screenshot, for those who cannot see the table spacing properly in the email

http://imgur.com/4W75H

-------
Sankalp



On 13 January 2012 07:42, Sankalp <address@hidden> wrote:
Hi,
I have the following situation :

#+TBLNAME: Totals
|--------+--------|
| Name   | Amount |
|--------+--------|
| xyz    |     90 |  <-- should evaluate to 130, not 90
|--------+--------|
| TOTAL  |        |
|--------+--------|
#+TBLFM: @2$2=remote(xyz,@>$4)  <-- I'm trying to refer to the last row, 4th column in table xyz

#+TBLNAME: xyz
|----------------+----------------------+------------------+--------|
| Title          | Description          | Date             | Amount |
|----------------+----------------------+------------------+--------|
| Trichy Tickets | Trichy Gig Travel    |                  |   1200 |
| PAID           |                      | [2011-10-16 Sun] |  -1000 |
| Blah           | Prior to Inorbit Gig | [2011-11-11 Fri] |     90 |
| InOrbit Money  | Payment for Gig      | [2011-11-11 Fri] |   -200 |
| Biryani        | Al-Saba              | [2012-01-07 Sat] |    120 |
| Sub            | Chicken Ham          | [2012-01-12 Thu] |    -75 |
| Blah           | I had asdad          | [2012-01-12 Thu] |     -5 |
|----------------+----------------------+------------------+--------|
| TOTAL          |                      |                  |    130 |
|----------------+----------------------+------------------+--------|
#+TBLFM: $4=vsum(@address@hidden)

Instead of showing 130, the formula in the "Totals" table is showing 90.

Upon some investigation, it becomes apparent that even though the formula should point to the last row in the remote table
(value 130), "@>" in the remote table reference is actually evaluating to "@3" (since the current table has 3 rows) instead
of evaluating to "@9" as expected (since the remote table has 9 rows).

Is this a bug? or am I making some mistake in the formula.

-------
Sankalp




reply via email to

[Prev in Thread] Current Thread [Next in Thread]