IF ELSE Statement not working

sa5

14-10-2020

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.

Accepted Solutions (0)

Answers (0)