Skip to Content
author's profile photo Gerald Kuiper
0
Gerald Kuiper

If statement

Posted on Aug 19, 2016 at 01:08 PM 22 Views

Hello,

I have a report that check a location of a part and it works. Now someone thru a wench into my report.

I have a part that is called B1113AA that has a quality, but when it goes to another location is called B1113UPSAA and has it's own quality.

In my report I only check for B1113AA part number but I want to check for quality in XXX location for part number B1113UPSAA

so I know I will have to use an if statement here.

if {INV_MSTR.PART_NUM} = 'B1113AA' then

// This is where I am lost for the next step.

{INV_MSTR.PART_NUM}='B1113UPSAA' use {INV_MSTR.QTY}

else

{INV_MSTR.QTY}

Any help would be appreciated.

Thank you,
Gerald

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Sastry Duvvuri
    Sastry Duvvuri
    Posted on Aug 22, 2016 at 07:23 AM
    2

    Hi Gerald,

    Use below :

    if {INV_MSTR.PART_NUM} = 'B1113AA' Then

    (

    If {INV_MSTR.PART_NUM}='B1113UPSAA' then {INV_MSTR.QTY}

    )

    else

    {INV_MSTR.QTY}

    Thanks,

    Sastry

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Abhilash Kumar
    Abhilash Kumar
    Posted on Aug 22, 2016 at 07:45 AM
    0

    Hi Gerald,

    Could you please elaborate on:

    "but when it goes to another location is called B1113UPSAA and has it's own quality."

    Is there a field in the database to indicate 'another location'?

    -Abhilash

    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.