Cross-reference calculations in a Straight Table

Wed, 08 Aug 2012 14:33:03 GMT

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

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)

...?

Re: Cross-reference calculations in a Straight Table

somenathroy — Wed, 08 Aug 2012 15:38:05 GMT

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