If IO-ch ='L' then KF=1

[Private_Member_9643]

Hi,

How do make this in BEx,

If some infoobject (characterstic) is having value 'L' the column should display output as 1, else it should display it as 0?

KJ!!!

[former_member188325 · Accepted solution]

Hi,

small correction from my previous post as i understd your question in a different way.

follow this procedure

1.Create a formula variable with replacement path on your infoObject.

2.create a formula say 'KF1' to diaply the value of InfoObject ('L') along with other KeyFigures. and Hide this formula.

(you need to go for formula variable as system doent allow you to insert characteristic directly into KF structure).

3.Now create a formula KF2 = (KF1<>0)

KF2 returns 1 if KF1 = 'L' otherwise 0.

thats it.(dont forget to have the characteristic in rows and hide it otherwise formula variable returns 'x')

you can achieve this by using restricted Kf also.But as i said in my previous post,you need to maiantain data for 'L' always.this method is if it is not possible to create formula variable on your characteristic.

regards

[Former Member]

Hi,

Do this

1) In Rows,Put your IO

and restrict it to some value like->"L" and "K" and etc.

2) In column,

Create a Res KF->KF1->drag your KF and your IO with "L"[exculde from the selection].

create another REs KF->KF2->drag your KF and your IO with "L" only.

Then create a Now Formula->

( 'KF2' <> 0 )

and save nad run.

Should work.

Regards,

San!

[former_member188325]

Hi,

it is almost not possible with Bex functionality to achieve this as system doesnt allow to use other than numbers in formula..

but as Manga suggested,it can be done if you make sure that data is always maintained for Kefigure for IO = 'L'.

in this case,you may get this using formula variable , restricted Kf and formula.

regards

[Former Member]

create a restricted keyfigure on the infobject , and have this value in some other variable or so ..to display..then read this variable and populate 1 or 0.

[Private_Member_9643]

Manga,

Could you elobrate more on this?

[former_member188972]

You'll use a formula with boolean condition.

Regards,

Sergio

[Private_Member_9643]

Sergio in formula i can only use KF's as conditions in bolean...like only IO= 'any numeric value'.

Do u think the same i can achieve using formula?