Relation to omit parameter in BOM

[wfalco]

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

[MartinHanak · Accepted solution]

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

[wfalco]

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

[wfalco]

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

[MartinHanak]

Hi,

I think you understand that I do not have enough time to guess what's wrong on your side.

Please prepare test-data (drawing, assembly, parts) and upload them. I will check repeat region then.

I responded too soon.

[wfalco]

No big. so did I. Thanks again. I knew it was something this simple.