Simple, if var = 1 then restart count

TMorville — Mon, 29 Oct 2012 17:52:06 GMT

Hi, i have a dataset with people rolling a dice, and i need to label them with a game number

I have a varible called trialCount. This goes from 1 to 13, and everytime it equals one, its a new game number.

Basically this is the stucture i have - except for game number:

trialCount totalTrialCount gamenumber (Dont have, but want!)

1 1 1

2 2 1

3 3 1

4 4 1

1 5 2

2 6 2

1 7 3

1 8 4

1 9 5

2 10 5

3 . 5

4 . .

5 .

So basically what i would like is something conceptually like:

When trialcount = 1

then gamenumber = "some loop that counts what game number we are at, and puts that number in"

until trialcount = 1 again, then start over

I can't really work this out. I can do a simple count + 1, first.count, but that dosen't really work here.

Hope you understand where im coming from!

Thanks

toby

Re: Simple, if var = 1 then restart count

art297 — Mon, 29 Oct 2012 18:09:11 GMT

why not just?:

if trialCount eq 1 then GameNumber+1;

Haikuo — Mon, 29 Oct 2012 18:50:40 GMT

Exactly, or equally:

Gamenumber+(trialCount eq 1) ;

Haikuo

TMorville — Mon, 29 Oct 2012 19:00:20 GMT

God i think i had too much coffee this evening.

Thanks for pointing out the obvious.