
Announcements
Is there screen function - similar to the InfoPath form using the Field - Count function?
A count function for the form used and fields.
Say I have a form/screen full of radio buttons and I wish to count how many have a Yes /No / NA (Not applicable), return, to establish out of the total buttons completed x percentage of the total has a yes answer and x percentage had a no answer.
Total returned Yes / [Total buttons returned - Total buttons NA]
Can this be done - so that a Card displays a percentage of the Radio buttons that answered yes for the user to see - instantaineously - a score result?
Can any calulations be done on the cards results in a Screen and displayed simultaneously on another card within the screen, using a function similar to what could be manipulated in InfoPath.
Hoping for the impossible....
Yes you can use CountIf() function. However it need 1 source so probably you'll need to join your radio collections and then filter they by .Selected.Value = 'Yes' (or whatever)
I think simplier is to on every OnSelect of every radio control increase/decrease some variable that will keep such information for you and just use such variable in checks.