cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Concatenate bulk item Qty with unit using relation in repeat region?

ZWei
Guest

Concatenate bulk item Qty with unit using relation in repeat region?

Is it possible to concatenate / combine the bulk item Qty with its unit as 1 parameter using relation in repeat region? 

ZWei_0-1615103986407.png

I would like to display the cell value as "BOM_Report_Quantity" + "Unit" 

Instead of 0.040 in the image below, i would like it to show as 0.040 g or 0.040 m depending on what unit user defined...

ZWei_1-1615104325292.png

 

 

My attempt so far: 

I had tried to use the following relation

bomqty=Y+asm_mbr_ptc_unit_bom_report_quantity  

Y is the rpt_qty converted into string. 

 

I could convert the rpt_qty to string (Y) but I am NOT able to concatenate it with the bom_report_quantity unit... 

It seem that &asm_mbr_ptc_unit_bom_report_quantity could not be display properly? 

 

Note: 

I do not want to create an additional parameter or column just for the unit if possible.

Announcements