Is it possible to carry out the same function as the basic statistics component within Pilot Script? For example, to return the sum of an entire property.
I'm currently trying things like the example below but it just returns the number that's in the corresponding property for that row and not the sum of the row.
For #i IN 1 .. 100
LOOP
#temp1 := #i * 5;
#temp1 := #temp2 * 5;
property('sum'.#i) := Sum(#temp2);
END LOOP;
Thanks for any help