count instance repeated values

[madman411]

I have a portal which displays a check list for the user. The status for each task are (in radio buttons): Passed, Failed, Comments & N/A.

 

I'm trying to put together a key next to the portal to display the count of each value. Basically, a running count of which tasks were Passed, Failed, etc. I would also like to display a count of which tasks didn't receive a status (i.e. left blank).

 

I've tried multiple functions but don't ever obtain the correct count. 

 

Please help!

[eos]

Try this one. If you feel adventurous, use ExecuteSQL and save some overhead, but this is a method that even I understand 

CountStatus_eos.fmp12.zip

[No_access]

you can create a script  and cycle thru the portal rows to get this real easy  - update each time they click a radio button.

 

it might be something like this

 

Go to Portal Row [select; First]

SET VARIABLE AND COUNT WHAT YOU WANT HERE IF(FIELD="PASS") THEN SET $VAR1 =1  ETC...

loop

Go to Portal Row [select; next;exit after last]

SET VARIABLE AND COUNT WHAT YOU WANT HERE  USE $VARIABLE+VARIABLE+1  HERE IE..IF(FIELD="PASS") THEN SET $VAR1+$VAR +1

end loop

[madman411]

Thanks guys!