Hi,
I am trying to build a statement where I want to first output a sum (total quantity) and then once there are changes, output the changed quantity. This is the script I have written:
if (Form.bdyMain.frmTableBlock.tblRemarkRowTable.rowItem.tblInnerTable.rowChanges.tblInnerCTable.rowCItem.colChangeText.rawValue == "Item cancelled" )
then
sum(tblRemarkRowTable.rowItem[*].tblInnerTable.rowItem.frmHiddenQuantity.decQuantity[*]) - Form.bdyMain.frmTableBlock.tblRemarkRowTable.rowItem.tblInnerTable.rowItem.frmHiddenQuantity.decQuantity.formattedValue;
else
sum(tblRemarkRowTable.rowItem[*].tblInnerTable.rowItem.frmHiddenQuantity.decQuantity[*]);
endif
Still can't get the total quantity summed, any help would be greatly appreciated. Thank you.
