Skip to main content
wfalco16-Pearl
16-Pearl
October 22, 2019
Solved

Relation to omit parameter in BOM

Hi all,

 

Could have searched this. But in somewhat of a hurry to get this done.

 

I am looking to blank certain cells in my bom that have the parameter "material" in the repeat region.

 

How do I write the relation?

 

Thanks,

 

WayneF

MartinHanakAnswer
24-Ruby III
October 23, 2019

Hi,

what parameter is placed in the "material" column ? Suppose it is &asm.mbr.compmat

 

1.] repeat region relations

IF asm_mbr_compmat=="2"

compmat2=""

ELSE

compmat2=asm_mbr_compmat

ENDIF

 

2.] when relations are created then replace &asm.mbr.compmat with &rpt.rel.compmat2 in "material" column

 

View in thread

5 replies

MartinHanak24-Ruby IIIAnswer
24-Ruby III
October 23, 2019

Hi,

what parameter is placed in the "material" column ? Suppose it is &asm.mbr.compmat

 

1.] repeat region relations

IF asm_mbr_compmat=="2"

compmat2=""

ELSE

compmat2=asm_mbr_compmat

ENDIF

 

2.] when relations are created then replace &asm.mbr.compmat with &rpt.rel.compmat2 in "material" column

 

Translate
    wfalco16-PearlAuthor
    16-Pearl
    October 23, 2019

    Martin,

     

    My parameter is "material".

     

    I tried both:

     

    IF asm_mbr_material=="2"
    material=""
    ELSE
    material=asm_mbr_material

    ENDIF

     

    &

     

    IF asm_mbr_material=="2"
    material2=""
    ELSE
    material2=asm_mbr_material

    ENDIF

     

    Neither work. I am most likely misunderstanding.

    The first one makes sense. The second one adding "material2" does not make sense.

    Oddly enough both are accepted. However the "2" remails in the matrail column.

     

    Wayne

    Translate
    wfalco16-PearlAuthor
    16-Pearl
    October 23, 2019

    My bad!!! I never changed for step 2. Awesome. Works! Thanks Martin!

    Translate
    Terms & ConditionsAccessibility statement