Defining the Rows of the Form 

Use

The form should contain five rows with the key figures Revenue , Contribution margin 1 and Contribution margin 1 in %.

Procedure

  1. Double-click Row 1.
  2. In the dialog box, select Key figure scheme element.
  3. In the next dialog box, select IDES det. CM scheme.
  4. This lets you choose key figures and formula calculations from a predefined structure.

  5. Choose .
  6. In the dialog box, enter the following data:
  7. Field

    Data

    Value field

    Gross revenue

  8. Choose Confirm.
  9. Double-click Row 2.
  10. In the dialog box, select Key figure.
  11. Choose .
  12. Enter the following data:
  13. Field

    Data

    Value field

    Contribution margin I

  14. Choose Confirm.
  15. Select Row 3.
  16. Choose Edit ® Rows ® Insert dividing line.
  17. In the dialog box, enter the following data:
  18. Field

    Data

    Underscore character

    =

  19. Choose .
  20. In the dialog box, choose Yes.
  21. Select Row 3 (which has now moved down a row).
  22. Choose Edit ® Rows ® Insert Blank Line.
  23. Double-click Row 3.
  24. In the dialog box, select Formula.
  25. Choose .
  26. In the dialog box, enter the following data:
  27. Field

    Data

    Description

    Text field

    Y002 %A Y001

    Contribution margin 1 as a % of gross revenue

  28. Choose .
  29. In the dialog box, enter the following data:
  30. Field

    Data

    Short

    CM1 in %

  31. Choose Copy Short Text.
  32. Choose .
  33. The screen now displays a field that contains a question mark and has a red background. The system cannot decide whether to calculate this field using the formula in the row or the formula in the column. In this case, however, the cell is deactivated.

  34. Select the cell with the red background and choose .
  35. In the dialog box, select Inactive.
  36. Choose .
  37. You now want to highlight the contribution margin 1 as a percentage.

  38. Position your cursor on the row CM 1 in %.
  39. Choose Formatting ® Color settings.
  40. In the dialog box, enter the following data:
  41. Field

    Data

    Color for emphasis

    Select

  42. Choose .
  43. Remain on the Report Painter: Create Form screen.