Tuesday, September 02, 2008

var ItemsCount = Field(“Total”).Items.Count;
var Sum = 0;
Field(“TotalAmount”).Value = Field(“TotalAmount”).Value.replace(” “,”“);
for( i = 0; i     Field(“Total”).Items.Item(i).Value = Field(“Total”).Items.Item(i).Value.replace(” “,”“);
    Sum = Sum + parseFloat(Field(“Total”).Items.Item(i).Value);
}
if (Sum != parseFloat(Field(“TotalAmount”).Value)) {
    CheckSucceeded = false;
    ErrorMessage = “Sum of values in Total column doesn’t match TotalAmount value”;  
    Field(“TotalAmount”).Suggest( Sum );
}
else {
    CheckSucceeded = true;
}

Tuesday, September 02, 2008 8:45:37 AM (Mountain Standard Time, UTC-07:00)  #    Comments [0]  | 

Pick a theme: