Skip to Content
0
Former Member
Nov 26, 2005 at 07:38 PM

Display only positive values for a particular Keyfigure

22 Views

Hi..

For a particular column(keyfigure) in my report, the user wants to display only positive values.

I used the formula from the one of the forums

(Keyfig > 0)* Keyfig.

This displays only positive values in the column as required. But, the result for this column is also affected. As the result is negative, it shows, zero in the result for this column.

Is there a way in which the result will not be affected by the formula?

I went into the properties of the particular keyfigure and chose Calculate Result as -> Summation.

It throws out the following error message

'Calculating result as...' was not executed

Message no. BRAIN141

Diagnosis

The function 'Calculate Results as ...' could not be used in all

instances.

The recalculation of a result cell always occurs based on the set of

detailed cells subordinated to this cell. This is the most detailed

level of the drilldown. Therefore it is not posible to recalculate in

hierarchical lists. The calculation of a results cell is not performed

if a cell or column with an expand symbol is assigned beneath it.

Otherwise the newly calculated result is changed every time one of its

lower-level nodes is expanded. This is not supported for technical

reasons and would also only confuse users.

Note, however, that calculating with "Suppress Results" is always

executed because the restriction described above does not apply in this

case.

NOTE:

The query shows the keyfigure values for a selected title, for profit center and territory hierarchies.

Any suggestions would be greatly appreciated.

Thanks,

Sai.