I updated to 7.5, recompiled, and now it works! Thanks for the help!
On Wed, Mar 9, 2011 at 9:46 PM, Nick Dokos <nicholas.do...@hp.com> wrote: > Rehan Iftikhar <rehan.iftik...@gmail.com> wrote: > >> I have tried adding >> >> #+TBLFM: @>$>=vmean(I..II) >> >> between the #+BEGIN and #+END lines (after generating a table), but >> when I C-c C-c on #+BEGIN, the table refreshes and removes the #+TBLFM >> line. >> >> I am using org-mode 7.4. Any idea why my formula isn't working? >> > > I don't know why the #+TBLFM line disappears: it does not in my case - > assuming that I've got org-collector loaded: since it's a contrib > package it's not loaded automatically for me and when I tried the > refresh before loading org-collector, *everything* disappeared: the > table and the formula. But once I got the package loaded correctly, > things worked as I described before: if only the formula is in there, it > gets wiped out, but if there is a table along with the formula, the > table gets refreshed and the formula is recalculated. > > BTW, the formula is wrong: it should read > > --8<---------------cut here---------------start------------->8--- > #+TBLFM: @>$>=vmean(@I..II) > --8<---------------cut here---------------end--------------->8--- > > and that also assumes that you are running a very recent version of org, > one that recognizes @> and $>. But neither of these would explain why > the formula is wiped. > > Nick > > PS. I'm using Eric Schulte's standard example from the Worg site: > > --8<---------------cut here---------------start------------->8--- > * Example > > #+BEGIN: propview :id "december" :conds ((string= spendtype "food")) :cols > (ITEM amount) > | "ITEM" | "amount" | > |----------------------------------+----------| > | "Grocery Store [2008-12-01 Mon]" | 56.77 | > | "Restaurant [2008-12-08 Mon]" | 30.67 | > | "Grocery Store [2008-12-09 Tue]" | 56.76 | > |----------------------------------+----------| > | | | > #+TBLFM: @>$>=vmean(@I..II) > #+END: > > > > #+BEGIN: propview :cols (ITEM (+ 400 amount)) :scope tree :match "example" > | "ITEM" | "(+ 400 amount)" | > |----------------------------------+------------------| > | "December Spending" | 0 | > | "Week One" | 0 | > | "Grocery Store [2008-12-01 Mon]" | 456.77 | > | "Athletic club [2008-12-02 Tue]" | 475.0 | > | "Week Two " | 0 | > | "Restaurant [2008-12-08 Mon]" | 430.67 | > | "Grocery Store [2008-12-09 Tue]" | 456.76 | > |----------------------------------+------------------| > | | 259.88571 | > #+TBLFM: @>$>=vmean(@I..II) > #+END: > #+TBLFM: @>$> = vmean(@I..II) > ** December Spending > :example: > :PROPERTIES: > :ID: december > :END: > > *** Week One > **** Grocery Store [2008-12-01 Mon] > :PROPERTIES: > :amount: 56.77 > :spendtype: food > :END: > **** Athletic club [2008-12-02 Tue] > :PROPERTIES: > :amount: 75.00 > :spendtype: health > :END: > *** Week Two > **** Restaurant [2008-12-08 Mon] > :PROPERTIES: > :amount: 30.67 > :spendtype: food > :END: > **** Grocery Store [2008-12-09 Tue] > :PROPERTIES: > :amount: 56.76 > :spendtype: food > :END: > --8<---------------cut here---------------end--------------->8--- > >> >> On Sat, Mar 5, 2011 at 12:48 AM, Nick Dokos <nicholas.do...@hp.com> wrote: >> >> Rehan Iftikhar <rehan.iftik...@gmail.com> wrote: >> >> >> >> > * More Complex Example: displaying the mean of the "Amount" column >> >> > for each week. >> >> > >> > >> > I see that I misread this: the formula calculates the mean of all the >> > entries, >> > not the mean for each week. Having thought about it for about 10 seconds, >> > I cannot think of a way to do that. >> > >> > Nick >> > >> >> >> >> -- >> -Rehan >> > -- -Rehan
