How can i do mathematical calculation in BOM table
ITable affTable= item.getTable(ItemConstants.TABLE_BOM);
Iterator it1=affTable.iterator();
while(it1.hasNext())
{
IRow row=(IRow) it1.next();
ICell cell = row.getCell(ItemConstants.ATT_BOM_BOM_TEXT01);
def v2 = row.getCell(ItemConstants.ATT_BOM_BOM_NUMERIC01).toDouble();
v3 = (v1.multiply(v2)).toString();
cell.setValue(v3);
}
In above code when i define
def v2 = obj.getValueByAttId(ItemConstants.ATT_BOM_BOM_NUMERIC01).toDouble();
It fetches the value from last bom Table and performing multiplication.
when using def v2 = row.getCell(ItemConstants.ATT_BOM_BOM_NUMERIC01).toDouble();
We are getting bellow exception.
No signature of method: com.agile.api.pc.CellRedlined.toDouble() is applicable for argument types: () values: {}
Please help me how can i fix this.
Thanks in Advance……
dinesh,
Did you resolve this? And if yes, what did you find out? Could you leave some insight for us here?
