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

[Sankalp <sankalpkhare@gmail.com>]

[-- Attachment #1: Type: text/plain, Size: 2349 bytes --]

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 <sankalpkhare@gmail.com> 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 <sankalpkhare@gmail.com> 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(@2..@-1)
>>
>> 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
>>
>
>

[-- Attachment #2: Type: text/html, Size: 6123 bytes --]