Using a sum of a block in a formula or variable of another

building reports desktopintelligence
1

Greetings BO community,

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. Any help much appreciated.
Guy Zelck
(guy.zelck@eds.com)

Listserv Archives (BOB member since 2002-06-25)

2

ock.

in first block, you’ll simply display, , and Sum() in the footer.

In second block you display , , where =/Sum(Revenue) ForAll

– Vasan

From: Zelck, Guy

block.

Greetings BO community,

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. Any help much appreciated.
Guy Zelck
(guy.zelck@eds.com)

Listserv Archives (BOB member since 2002-06-25)

3 
          another bl
          ock.

in first block, you’ll simply display, ,
and Sum() in the footer.

In second block you display , ,
where =/Sum(Revenue) ForAll

– Vasan

-----Original Message-----
From: Zelck, Guy
Sent: Tuesday, December 22, 1998 7:19 AM

block.

Greetings BO community,

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.
Any help much appreciated.
Guy Zelck
(guy.zelck@eds.com)

Listserv Archives (BOB member since 2002-06-25)