[O] Referring to the Last Row of a Remote Table using @
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
Re: [O] Referring to the Last Row of a Remote Table using @
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 sankalpkh...@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
Re: [O] Referring to the Last Row of a Remote Table using @
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 sankalpkh...@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 sankalpkh...@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