Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X

Translate the entire conversation x

Leading zero for BOM

Mani_designer
10-Marble

Leading zero for BOM

Hi mates, Could you someone tell me how to add leading zero for BOM sl.nos, and qty column like 01,02,03... Instead of just 1, 2, 3... In creo 7 or latest?

 

Thanks in advance 

4 REPLIES 4

Hi,

you have to define repeat region relations.

my_qty=extract("0"+itos(rpt_qty),string_length("0"+itos(rpt_qty))-1,2)

MartinHanak_1-1738766085462.png

MartinHanak_2-1738766131765.png

 

 


Martin Hanák

Hi , 

After input the relation i got "Invalid symbol"error. Did I missed something?

17388263520848624695363049522112.jpg

You need to change the parameter in your table from rpt_qty to My_qty.

Yours should be:

&rpt.rel.My_qty

 

This is in my table:

&rpt.rel.newqty

 

This is in my relation:

IF asm_mbr_pn == "9594"

NEWQTY = "0.5"

ELSE

NEWQTY = rpt_qty

ENDIF

 

Hi,

check whether repeat region attribute is set to No Duplicates.

If &rpt.qty is not included in repeat region column, then you have to add rpt_qty parameter manually in relations dialog box.\

MartinHanak_0-1738951932102.png

Type of the parameter is irrelevant. Creo will set it to Unknown.


Martin Hanák
Announcements


NEW Creo+ Topics: Real-time Collaboration

Top Tags