cancel
Showing results for 
Search instead for 
Did you mean: 

Display only positive values for a particular Keyfigure

Former Member
0 Kudos
748

Hi..

(Sorry, I accidentally posted this also in Datawarehousing forum, actually it related to BeX forum).

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Is the expected result for the results rows the sum of the positive and negative values or just positive values?

If it is both the values you can use the LEAF boolean operator for doing a seperate calculation for results and details row. Use the epxression given below, in this case only the positive values will be displayed for details row and the results rows will not be affected.

LEAF (keyfig)((Keyfig > 0) Keyfig)+ NOT LEAF(keyfig)*keyfig

You can also try creating a condition in the query which will display only the values greater than 0 for the key figure.

Thanks.

Former Member
0 Kudos

Hi Deepu,

Thanks for the reply. I tried with ur formula.

LEAF(keyfig) gives all values "zero" for that particular column including the result.

NOT LEAF(keyfig) gives all values "one" for that particular column including the result.

So, ur formula gives the same values as of the present column values.

I tried condition, but it's not working...it says the following errors...

There is a condit. on Title, results row suppress. active on Profit Center

(conditional

Message no. BRAIN144

Diagnosis

Characteristic Title has an output condition and the 'Suppress Results

Cells' property is active for Profit Center. This generally leads to an

incomprehensible output list.

System response

As soon as an output condition is defined for a characteristic (here

Title), the system calculates the corresponding result cells and applies

the output condition. If a result cell of this type is later deleted by

the condition, all the lower-level detail and result cells in its

drilldown are suppressed. Because the result cell is suppressed the

Title rows are then omitted from Profit Center.

In extreme cases this can lead to an entirely empty list being

displayed, although the single rows or columns would be displayed if the

condition were deactivated.

Procedure

Check the query settings, especially results row suppression and the

output conditions.

Procedure for System Administration

You can deactivate this message Brain 144 with transaction RSRT1.

There is a condit. on Profit Center, results row suppress. active on

Territory as in SPL (conditional

Message no. BRAIN144

Diagnosis

Characteristic Profit Center has an output condition and the 'Suppress

Results Cells' property is active for Territory as in SPL. This

generally leads to an incomprehensible output list.

System response

As soon as an output condition is defined for a characteristic (here

Profit Center), the system calculates the corresponding result cells and

applies the output condition. If a result cell of this type is later

deleted by the condition, all the lower-level detail and result cells in

its drilldown are suppressed. Because the result cell is suppressed the

Profit Center rows are then omitted from Territory as in SPL.

In extreme cases this can lead to an entirely empty list being

displayed, although the single rows or columns would be displayed if the

condition were deactivated.

Procedure

Check the query settings, especially results row suppression and the

output conditions.

Procedure for System Administration

You can deactivate this message Brain 144 with transaction RSRT1.

************************

Thank you very much.

Regards,

Sai.

Answers (0)