weight*qty

[ptc-1232746]

hai friends thanks in adwance how can i get weight multiplication with quantity. can anybody help? index description qty weight weight*qty 1 xxxxx 2 50 100 2 yyyyy 3 20 60

[AmolKinkar]

Create a parameter in start up model i.e unit_wt insert relation unit_wt=pro_mp_mass then go to startup template add one coloum as qty and report parameter for this will be rpt_qty then go to repete region --relation--select bom repete region--add relation as total_wt=rpt_qty*asm_mbr_unit_wt u will get the o/p

[samritkar]

Hi can you please show this with snapshots?

[BenLoosli]

1) assign a material to your parts

2) (optional) create a relation for weight in your part - weight = pro_mp_mass

3) in your assembly, create the BOM repeat region

4) add a column for the quantity used in the assembly by adding a column and using rpt,qty as the parameter

5) add a column for the weight, either use asm.mbr.Weight (if you added this to your parts) or asm.mbr.pro_mp_mass (this is added as asm.mbr user defined, then enter pro_mp_mass)

6) create a repeat region relation for total_wieght and set it to the quantity * the mass (rpt.qty * asm.mbr.weight) or (rpt.qty * asm.mbr.pro_mp_mass)

7) add a repeat region column to the BOM with rpt_rel.Total_weight

[samritkar]

It works!! Thank you for the help!!