SAP Reports 2011, WIN, INTL, NUL 7090310 User Manual
Product codes
7090310
1.
Right-click the top-left corner of your Cross-Tab.
2.
On the shortcut menu, point to Advanced Calculations, and click Calculated Member.
The Cross-Tab Calculated Members Expert appears.
3.
In the Calculated Members box, use the arrows to change the processing order of the Calculated
Members.
Members.
4.
Click OK to save your changes and return to your report.
The Cross-Tab recalculates the values of the Calculated Members.
Note:
Changing the processing order of Calculated Members does not cause a database refresh.
15.6.1.4 Calculation Formulas
Calculation Formulas are mathematical formulas that Crystal Reports uses to determine Calculated
Member cell values. You can choose between several pre-defined formulas or design your own in the
Formula Workshop.
Member cell values. You can choose between several pre-defined formulas or design your own in the
Formula Workshop.
The pre-defined formulas are as follows:
•
Sum of
•
Difference of
•
Product of
•
Quotient of
Crystal Reports is equipped with a variety of functions to help you design your own formulas.
15.6.1.4.1 To edit a Calculation Formula
1.
In the Calculated Member you would like to edit, right-click any cell except for the header.
2.
On the shortcut menu, point to Calculated Member, and click Edit Calculation Formula.
The Formula Workshop appears.
3.
In the Formula Workshop, enter the desired Calculation Formula.
4.
Click Save and close to return to your report.
The Calculated Member displays the results of the new Calculation Formula.
15.6.1.5 Header Formulas
Header Formulas determine the visible row or column header for a Calculated Member.
2011-05-16
338
Cross-Tab Objects