April 17, 200619 yr 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?
April 17, 200619 yr 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.
Create an account or sign in to comment