Rep

[RyanN]

Hello to All,

 

My question is I have a Repeating field made up of 16 repetitions. it has a Pop Up Menu with "CFrame" and "Versa Punch" as choices. I thne have two seperate fields to calculate how many times "Versa Punch" randomely appears and another field to calculate how many times "CFrame" Apears. The results I would like to be a number. How do I set up the fields to do a count from the repeating field.

 

Thank You.

[Maarten Witberg]

hi. i think you need to do it in two steps:

 

cIntermediate=calc, repeating 16, number result=PatternCount(YourRepeatingField;"CFrame")

cCountCframe=calc, number result= sum(cIntermediate)

 

same goes for the string "versa Punch".

 

kjoe

[aaa]

You can do it by two ways:

1. Writng script which runs through all records and calculates how many "Cframe" and "Versa Punch" there are.

2. Split your records by export or import to file then in this file do what you want.

[aaa]

Sorry, Kjoe! When i was posting my post your post was not here.

[Maarten Witberg]

no problem aaa

 

kjoe

[comment]

If you really want to go that way, then you could make the repeating calc a bit more efficient, by counting both values:

 

Case (

repeatingfield = "CFrame" ; 1 ;

repeatingfield = "Versa Punch" ; 17

)

 

Let's call the sum of this repeating calc theCode.

 

Count "CFrame" =

Int ( Mod ( theCode ; 17 ) )

 

Count "Versa Punch" =

Int ( Mod ( theCode ; 17 ^ 2 ) / 17 )

 

 

Of course the correct way is NOT to use repeating fields for data that needs to be summarized.

 

 

----

P.S. "The Count of Versa Punch" has a nice ring to it, no?

[Maarten Witberg]

[ QUOTE ]

P.S. "The Count of Versa Punch" has a nice ring to it, no?

 

 

[/ QUOTE ]

he should be in Sesame Street next to Count von Count

 

kjoe