Adding Values together from same field 1

[gavinjb]

I have a field which returns 14 vaslues seperated by a comma, (eg 245.67,128.90,126.54,0,0,0,0,0,0,0,0,0,0,0). I need to be able subtract all these values and add them all together, does anyone have any ideas how this can be done.

Regards,



Gavin,

 

[Reebo99]

This should help, change the item in bold with your field :

Local StringVar Input := "245.67,128.90,126.54,0,0,0,0,0,0,0,0,0,0,0" ;
Local NumberVar Counter := 0;
Local NumberVar Output := 0;

Local StringVar Array Values := Split(Input,",");
While Counter <> UBound(Values) Do
(Counter := Counter +1;
Output := Output+ToNumber(Values[Counter]);
Output;

Enjoy...

Reebo