cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Infopth Equivalent to Fx - Field - Count ?

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....

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Kudo Commander
Kudo Commander

Re: Infopth Equivalent to Fx - Field - Count ?

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.

View solution in original post

1 REPLY 1
Highlighted
Kudo Commander
Kudo Commander

Re: Infopth Equivalent to Fx - Field - Count ?

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.

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (10,125)