Bex formula

[Former Member]

Hi Experts,

I need identify as 'promotional' some materials when the 3º number in the code is "0", but I have not any char or attribute to identify they.

ex: if code = 12086 then dont show in report (because is promotional)

if code = 12186 then show in report (because is not promotional)

How can I do?

Thank you in advance,

Sandra.-

[Former Member]

closed

[former_member188975]

Hi,

You can create a formula variable by replacement path to pick up the key of this char and then in the same variable definition choose offsets to pick up the 3rd number of the key. Then create a formula using this formula variable, and then a condition that will display only those records where the formula KF is more than 0.

Hope this helps...

[Former Member]

Sorry for this But can i know How offset works in Formula Variable?

I know offeset for KeyFigures like creating buckets based on Date. Can you explain more what you are refereing.

[former_member188975]

Hi,

You can read more about it here:

http://help.sap.com/saphelp_nw04/helpdata/en/03/6ba03cc24efd1de10000000a114084/content.htm

Hope this helps...

[Former Member]

Thanks Very Much. Sorry could not able to assign Points

[Former Member]

Thank you Bhanu, is a very good trick.

I see that is the way in order to obtain a "text" string.

In need read this offset and compare this with the material code (0material), in order to validate when a materials contains this string as part of the material code.

Is this possible?

Thank you in advance!