I'm afraid I can't quite wrap my head around this puzzle. I have a little table: | Budget | 640 | 640 | | Some expense | -165 | 475 | #+TBLFM: $3=$LR3+$2 So col C is supposed to add the previous line's col C to the current line's col B. However, it seems that $LR3 is referring to the _subsequent_ line not the previous one. Is there a bug or just my misunderstanding? Thanks.
Andrew wrote:
> I'm afraid I can't quite wrap my head around this puzzle. I have a little table:
>
> | Budget | 640 | 640 |
> | Some expense | -165 | 475 |
> #+TBLFM: $3=$LR3+$2
>
> So col C is supposed to add the previous line's col C to the current
> line's col B.
>
> However, it seems that $LR3 is referring to the _subsequent_ line not
> the previous one. Is there a bug or just my misunderstanding?
>
> Thanks.
Hi Andrew,
what you need is this:
| | | 0 |
| Budget | 640 | 640 |
| Some expense | -165 | 475 |
#+TBLFM: $3=@-1+$2::@1$3=0
the LR-reference is for the last, that is, the bottom row.
You need the first row and the field formula for C1 in order to initialize the
cumulative sum properly.
hth,
Stephan
Stephan wrote:
> Andrew wrote:
>> I'm afraid I can't quite wrap my head around this puzzle. I have a
>> little table:
>>
>> | Budget | 640 | 640 |
>> | Some expense | -165 | 475 |
>> #+TBLFM: $3=$LR3+$2
>>
>> So col C is supposed to add the previous line's col C to the current
>> line's col B.
>>
>> However, it seems that $LR3 is referring to the _subsequent_ line not
>> the previous one. Is there a bug or just my misunderstanding?
>>
>> Thanks.
>
> Hi Andrew,
>
> what you need is this:
>
> | | | 0 |
> | Budget | 640 | 640 |
> | Some expense | -165 | 475 |
> #+TBLFM: $3=@-1+$2::@1$3=0
>
> the LR-reference is for the last, that is, the bottom row.
>
> You need the first row and the field formula for C1 in order to
> initialize the cumulative sum properly.
>
> hth,
> Stephan
>
p.s.
another solution would be:
| Budget | 640 | 640 |
| Some expense | -165 | -165 |
#+TBLFM: $3=@-1+$2::@1$3=@1$2
Greetings,
Stephan
Stephan wrote:
>
> Stephan wrote:
>> Andrew wrote:
>>> I'm afraid I can't quite wrap my head around this puzzle. I have a
>>> little table:
>>>
>>> | Budget | 640 | 640 |
>>> | Some expense | -165 | 475 |
>>> #+TBLFM: $3=$LR3+$2
>>>
>>> So col C is supposed to add the previous line's col C to the current
>>> line's col B.
>>>
>>> However, it seems that $LR3 is referring to the _subsequent_ line not
>>> the previous one. Is there a bug or just my misunderstanding?
>>>
>>> Thanks.
>>
>> Hi Andrew,
>>
>> what you need is this:
>>
>> | | | 0 |
>> | Budget | 640 | 640 |
>> | Some expense | -165 | 475 |
>> #+TBLFM: $3=@-1+$2::@1$3=0
>>
>> the LR-reference is for the last, that is, the bottom row.
>>
>> You need the first row and the field formula for C1 in order to
>> initialize the cumulative sum properly.
>>
>> hth,
>> Stephan
>>
>
> p.s.
> another solution would be:
>
> | Budget | 640 | 640 |
> | Some expense | -165 | -165 |
> #+TBLFM: $3=@-1+$2::@1$3=@1$2
>
> Greetings,
> Stephan
>
p.p.s.
forgot to say: you must evaluate the formulas twice (C-u C-u C-c C-*)
| Budget | 640 | 640 |
| Some expense | -165 | 475 |
#+TBLFM: $3=@-1+$2::@1$3=@1$2