Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
...?
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