Skip to main content
1-Visitor
February 17, 2009
Question

weight*qty

  • February 17, 2009
  • 1 reply
  • 3433 views
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

    1 reply

    1-Visitor
    February 17, 2009
    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
    1-Visitor
    April 12, 2017

    Hi can you please show this with snapshots?

    23-Emerald III
    April 18, 2017

    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