OR condition in Restricted KeyFigure

[Former Member]

Group,

Please help us solving a BEx query development issue we are facing.User request is to calculate a keyfigure using multiple restriction using OR condition.

Example: Balance for Company Code = '1110' OR Version = '000'

If I create a Restricted KeyFigure it will look for company code 'AND' version combination but the requirement is Balance need to be calculated based on OR.

Please help.

Thanks,

Bobby.

[Former Member]

Hi,

Used 2 restricted keyfigures and one formula to achieve this functionality.

Thanks,

Bobby

[Former Member]

hai booby

get all the balances in one field then create a new formula

(company code==30 OR version ==00)*balance

try this

check this link for any more help

http://help.sap.com/erp2005_ehp_02/helpdata/en/5b/d2331b43c611d182b30000e829fbfe/frameset.htm

if helpful assign points

regards

abi ram

[Former Member]

Try to use 'ELSE' in place of OR.

[Former Member]

Venkat,

Can you please explain little detail of how to use ELSE for a keyfigure?

Thanks,

Bobby.

[Former Member]

Thatz simple extension of the OR condition with AND condition. Here you will be defining this in a new formula. Well, since this is related to chars you can go for a query condition.

[Former Member]

Venkat,

Let me explain my requirement in detail.In report output user is going to have a Field "Balance".

This is calculated based on the condition that Channel = 30 only OR version =00. That means it has to consider all balances for which Channel = 30 OR Version = 00 OR both.That means if channel = 30 but version is not eqaul to 00 still it need to be considered while calculating Balance.

I hope I am clear here.

Thanks,

Hema.

[Former Member]

Bobby,

In such a case restrict the balance keyfigure in the column with channel = 30 and version = 00. Again in another column restrict teh same key figure with channel = 30 and version <> 00. Hide these both columns and in a new formula add these both. This should solve ur problem.