Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cross-reference calculations in a Straight Table

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

Income
= a complex expression A

Expenses

= a complex expression B

Balance

30 00025 0005000
25 00026 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)

...?

1 Reply
somenathroy
Creator III
Creator III

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