Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

IF ELSE Statement not working

sa5
Level 1
Level 1

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.

0 Replies