In a message dated 99-02-02 16:26:36 EST, you write:
I am trying to figure out how to use the grand total column of a cross tab
to do more math.
Irene:
This is an issue that is not documented very well. But can actually be quite
simple.
To use a “grand total” anywhere in the report, you can add the words “In
Report” to the end of any formula. For example, if you have a
object, then the results of the Sum() formula would change based on
where you might put the formula on your report. But the formula
Sum() In Report
would always provide the grand total, no matter where it is placed. So, to
calculate the percentage in your crosstab, you would do:
/ Sum () In Report
I think it has been a while since it has been mentioned, and there may be
enough new participants on the list, that I can be forgiven for pointing you
to a presentation on our web site that details this an other issues with
… you will find presentations that I and others from my company have done at
the BusObj user conferences. The one I would suggest you check out that will
answer this an potentially other questions is called “Variables and More
Variables!” which was presented at the 1997 conference. The “Sequel” that was
presented last year is not completely set up on our web site yet. I hope to
have that done soon.
The column total, row total, and grand total cells are a result of using the
calculation function in the cross tab. Now I need to divide each of the
column totals by the grand total to get a percentage. The problem I’m
having is that the formula is simply =Sum(<Revenue(Static)>) for both the
column total cell and the grand total cell. Is there another way to do
this?
More complex formula examples are documented in the “Advanced calculations guide”,
which should come on your CD in the “manuals” folder. Or, directly from the
techsupport web page.
Hope this helps
Walter
DI Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna / Austria
Tel: +43-1-8151456-12, Fax: +43-1-8151456-21
e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at
The column total, row total, and grand total cells are a result of using
the
calculation function in the cross tab. Now I need to divide each of the
column totals by the grand total to get a percentage. The problem I’m
having is that the formula is simply =Sum(<Revenue(Static)>) for both the
column total cell and the grand total cell. Is there another way to do
this?
You could try defining your calculations for the column totals and grand
totals as Variables. You can then divide each column total variable by the
grand total variable. The use of variables does, however, cause an
increase in the physical size of the BusinessObjects Document.
You can define your global total as variable ( you have to have your
formula bar visible)in the ‘Define as Variable’ window, click the radio
button ‘Evaluate the formula in its contexts’ and name it lets say
‘Global Total’ then use this newly defined variable in your formula
(i.e., measure/).
I hope this helps.
patw
Hi Everyone,
I am trying to figure out how to use the grand total column of a cross
tab
to do more math.
The column total, row total, and grand total cells are a result of
using the
calculation function in the cross tab. Now I need to divide each of
the
column totals by the grand total to get a percentage. The problem I’m
having is that the formula is simply =Sum(<Revenue(Static)>) for both
the
column total cell and the grand total cell. Is there another way to do
this?