Salesforce and other SMB Solutions are coming soon. ×

# Rep

## Recommended Posts

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.

##### Share on other sites

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

##### Share on other sites

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.

##### Share on other sites

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

no problem aaa

kjoe

##### Share on other sites

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?

##### Share on other sites

[ 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

#### Archived

This topic is now archived and is closed to further replies.

• ### Images

• By Soliant Consulting,
• By Soliant Consulting,
• By Soliant Consulting,
• ### Forum Statistics

• Total Topics
33.7k
• Total Posts
141.5k
×
×
• Create New...