Skip to Content
author's profile photo Former Member
Former Member

Bex formula

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.-

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Oct 09, 2007 at 07:16 PM

    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...

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Bhanu Gupta

      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!

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 03:45 PM

    closed

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.