create cursor foo (f1 N(2),f2 c(2))
insert into foo values(1,"AA")
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")
LOCATE  && <------------------------------------------------- add this here

Average f1 next 2 for f2 = "BB" to m.myvar
?m.myvar 

locate for f2 = "BB"  &&& i figured it out later
Average f1 next 5 for f2 = "BB" to m.myvar
?m.myvar ---  returns 3+3/2 actually an average
locate for f2 = "BB"
Average f1 next 3 for f2 = "BB" to m.myvar
?m.myvar ---  returns 3 as average because it is 3/1