Jump to content

Counting Repeating Radio Button


This topic is 5713 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I know this is easy, but for some reason I am drawing a blank. Is there a way to count a repeating field of radio buttons. I have a 53 line repeating field called "Call Type". It is a radio button with 2 options "In" and Out". I need to get a count of all "In" for each record.

Any ideas?

Link to comment
Share on other sites

There may be a more efficient way, but this is what I came up with: Define two additional calc fields:

Call Type In (calculation; number result; repeating [53])= Call Type = "In"

Count of Call Type In (calculation; number result)= sum(Call Type In)

If you were using a portal to another table instead of the repeating field (you should seriously consider this, BTW,) this could instead be done with one additional filtered relationship and one count() calc.

Link to comment
Share on other sites

This topic is 5713 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.