=?iso-8859-1?Q?riable_of_another_block.?= Mime-Version: 1.0
Guy Zelck wrote
(quote)
In one block I have calculated the Revenue per account with the total revenue in the footer of the block (as a sum aggregate). I now need to use this Total Revenue to build another block in which the Expenses are represented as a % of Total Revenue for each account, i.o.w. the formula is Expense/Total Revenue. How can I define this Total Revenue to
obtain this. If Total Revenue could be defined as a constant I could simply create a nother variable like ExpensePerCent=Expense/TotalRevenue (with Expense being the only object). But this is not possible I guess. (unquote)
For the total revenue, you have a formula Sum() Define it as a variable (for instance TotalRevenue), using the “Evaluate formula in its context” option.
Then ExpensePerCent=Expense/TotalRevenue should work.
Christophe GROS
Listserv Archives (BOB member since 2002-06-25)