Excluding N/A from gallery count

[oappdev]

Hello Power Apps Community,

I know it is something simple. Shooting a blank this morning. I would like to exclude N/A from the gallery count.

Formula:

CountRows(
    Filter(
        Gallery2.AllItems,
        !IsBlank(RadioYesNoOtherNA)
    )
) & " of " & CountRows(Gallery2.AllItems) & "  " & "Completed"

As always, Thank you in advance.

[BCLS776]

You'll want to add an argument to your Filter() to show the desired responses (other than N/A) for your CountRows().

If you can share the column name from your gallery's Items, we can help you build the exact syntax.

Hope that helps,

Bryan

[oappdev]

Thank you so much @BCLS776 for the quick response. I have been under a lot of stress with this Solution.

Radio Button Name: RadioYesNoOtherNA

Radio Items: Table({Answer:"Yes", Value:"100"},{Answer:"No", Value:"0"},{Answer:"N/A", Value:"1"},{Answer:"Other"}).

Let me know if you i need an additional screen shot?

[BCLS776 · Accepted solution]

Try this:

CountRows(
    Filter(
        Gallery2.AllItems,
        !IsBlank(RadioYesNoOtherNA),
        Answer = "Yes" || Answer = "No" || Answer = "Other"
    )
) & " of " & CountRows(Gallery2.AllItems) & "  " & "Completed"

[oappdev]

@BCLS776 ,

Is giving me the following message.

[BCLS776]

Ah, I see what I did wrong - can you change 'Answer' to whatever the name of the column is from Gallery2's Items? I'm assuming there is a field in that table that controls the radio button value for each item.

[oappdev]

Thank you @BCLS776 , that did the trick. Much appreciated!