Forcing a formula before grouping.

building reports desktopintelligence
1

Hi ,

I am new to Business Objects, please excuse me if my question is very
trivial.

Can you force a formula to be calculated before grouping in a slice and
dice report, this formula is declared for a variable which is attached
to a column in the report. If this is not possible then is there a work
around and what is it ??

Any help would be greatly appreciated,

Thanks in Advance,
Satish.

Get Your Private, Free Email at http://www.hotmail.com

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

2

Satish,

snip>> Can you force a formula to be calculated before grouping in a slice
and

dice report <<snip

You can try stating the context of each object used in the explicitly using
functions like In, ForEach, ForAll.

Example: Say you have a table containing Revenue grouped by Account Number.
To return a Percent of Total Revenue for each Account Number, use the
following formula:

= ForEach / ForAll

Steven Jones
Consultant to BT Office Products International
sjones@btopi.com

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

3

Satish,

is your question about being able to do something else than the “default
calculation”?

If so, the answer is yes:

  1. Go to your formula and do “Define as variable” in the formula bar.
  2. Select “Evaluate formula in its context”
  3. Click Ok.

HTH,

-Harri

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