iRage Posted April 17, 2006 Posted April 17, 2006 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?
Ender Posted April 17, 2006 Posted April 17, 2006 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.
Recommended Posts
This topic is 6857 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 accountSign in
Already have an account? Sign in here.
Sign In Now