Cross-reference calculations in a Straight Table

[#1]

Let's have a Chart (Straight Table) with something like the following:

Income = a complex expression A	Expenses = a complex expression B	Balance
30 000	25 000	5000
25 000	26 000	-1000

Question: Is there some 'shortcut' to define the expression for the Balance by referencing the results of the other expressions, something like...

     = Income - Expenses

...without having to repeat the expressions with something like this for the Balance expression...

     =(a complex expression A) - (a complex expression B)

...?

[somenathroy]

Hi,

If Income is the first expression and Expenses is the second expression in expression list, you can calculate

Balance = Column(1) - Column(2)

Regards,

Som