seperate a sum total field into individual fields

[dnanhawk]

I have a report which I created a "sum" field.

I need to seperate each position of that "sum" field to add to come up with another "sum" field.

example: 763.21 I need to come up with the sum of each position 7 + 6 + 3 + 2 + 1 = 19

Any ideas on how to accomplish this??????????

 

[lbass]

numbervar x := {table.sumfield};
stringvar y := replace(totext(x),".","");
numbervar i;
numbervar j:= len;
numbervar z := 0;
for i := 1 to j do(
z := z + val(y)
);
z

-LB

 

[dnanhawk]

Thank you so much that worked perfectly!!!!!!!!!!!!!!