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

[Sankalp]

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