Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Overall Result

Friends,

I have two KF - Forecast Amount and Actual Amount, enter in the Key Figure.

Instead of display this Key Figure in the COlumn, I drag-and-place the Key Figure structure in the Row.

I have managed to suppress the Zero record by the following:

1) In Query Designer -> Query Properties ->Rows/Columns tab ->

Suppress Zeros = Ativae (All Values=0)

Effect On = Row

2) Click on the Key Figure structure Properties ->Display tab, tick the Apply Zero Row Suppression to This Structure.

With this, if the KF Forecast Amout or Actual Amount (whole row) now is zero, then it will be not be displayed on the screen.

No problem with this, work fine. However, on the Overall Result, it is still showing the zero row. For example:

Cost Centre..................................Fiscal Year

156700............Forecast Amount...0 --->(this does not show on the output screen because of the above setting, which is correct)

......................Actual Amount......35000

Overall Result..Forecast Amount...0 --->(Why this still show in Overall Result?)

......................Actual Amount......35000

How can we manipulate the Overall Result section? How can we hide the zero Row in the Overall Result?

I also dont want to display the Overall Result on the Right column.

But in the Query Properties ->Rows/Columns tab, we dont really have any setting to manipulate the Overall Result.

Please advice.

Edited by: Linda on Sep 25, 2008 3:15 AM

Former Member
Not what you were looking for? View more on this topic or Ask a question