Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X
Is it possible to concatenate / combine the bulk item Qty with its unit as 1 parameter using relation in repeat region?
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...
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.