If statement

[former_member1107312]

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

[former_member205840 · Accepted solution]

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

[former_member1107312 · Accepted solution]

Thank you for that.  I not sure why I didn't think of a nested if statement.

I do appreciated the help.

[abhilash_kumar]

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