User`s guide

8.2.5.3 Troubleshooting group selection formulas
In some cases, no values will print when using a group selection formula, even though there are values
that match the selection criteria. Typically, in these cases:
• The group selection formula references another formula.
• The referenced formula is one that calculates the value of each group as a percentage of the total
value of all groups (in other words a subtotal as a percentage of a grand total).
8.2.5.3.1 To correct a group selection formula
1.
To get started, create a report using the sample database, Xtreme.mdb. Link the Customer and
Orders tables, then place the following fields in the Details section:
{customer.CUSTOMER NAME}
{customer.REGION}
{orders.ORDER ID}
{orders.ORDER AMOUNT}
Note:
Xtreme.mdb is located on the SAP Business Objects Support web site.
For each order, the report shows the customer that placed the order, the region in which that customer
is located, the order ID number, and the amount of the order.
2.
Group the report by the {customer.REGION} field.
3.
Insert a summary that subtotals the {orders.ORDER AMOUNT} field for each {customer.REGION}
group.
The program calculates a subtotal in the {orders.ORDER AMOUNT} field every time the region
changes. See Subtotaling data.
4.
Insert a grand total on the {orders.ORDER AMOUNT} field to see the total value of all orders placed.
5.
Create a formula named Percent that calculates each subtotal as a percentage of the grand total to
see the value of the orders for each region group as a percentage of all orders placed.
Sum({orders.ORDER AMOUNT}, {customer.REGION})
% Sum({orders.ORDER AMOUNT})
6.
Place the formula in the Group Footer section of the report.
7.
Reference the formula (@Percent) in a group selection formula that selects only those groups for
which the percentage (of subtotal to grand total) is less than 5% in order to find out which regions
individually contributed less than 5% of total sales:
{@Percent} < 5
When you click Check, you will receive the following error message:
This formula cannot be used because it must be evaluated later.
2012-03-14155
Sorting, Grouping, and Totaling