>create cursor foo (f1 N(2),f2 c(2)) >insert into foo values(2,"AA") >insert into foo values(3,"BB") >insert into foo values(2,"AA") >insert into foo values(3,"BB") >insert into foo values(2,"AA") >insert into foo values(3,"BB") >insert into foo values(2,"AA") > >Average f1 next 2 for f2 = "BB" to m.myvar > >?m.myvar && this returns 0 >>
create cursor foo (f1 N(2),f2 c(2)) insert into foo values(2,"AA") insert into foo values(1,"BB") insert into foo values(2,"AA") insert into foo values(3,"BB") insert into foo values(2,"AA") insert into foo values(3,"BB") insert into foo values(2,"AA") Average f1 for f2 == "BB" to m.myvar ?m.myvar && this returns 2 Average f1 all WHILE _tally < 1 for f2 == "BB" to m.myvar ?m.myvar && this returns 1