Countrows using Yes/No column from DV

(1) Share

Report

Posted on by ckserra33

419

Hi everyone. I am trying to use this code to countrows BUT cannot get it to work once I add in the Yes/No column.

CountRows(
Filter(
TSGResponses,
'TSGActive (TSGResponses)'.Yes,
dbam_gametitle = ThisItem.Value
)
) & If(
CountRows(
Filter(
TSGResponses,
'TSGActive (TSGResponses)'.Yes,
dbam_gametitle = ThisItem.Value
)
) = 1,
" response",
" responses"
)

Once I remove the Yes/No column, everything works great. If I start from scratch, using this code,

CountRows(

Filter(

TSGResponses,

'TSGActive (TSGResponses)'.No,

dbam_gametitle = ThisItem.Value

)

) it always counts the same thing, whether I use yes or no.

Any help would be amazing!

thanks

Chris

All responses (1)

Answers (0)

Ami K 15,665 Super User 2024 Season 1 on at

Like (0)

Report
Re: Countrows using Yes/No column from DV

@ckserra33 - try:

CountRows( Filter( TSGResponses, TSGActive = 'TSGActive (TSGResponses)'.Yes, dbam_gametitle = ThisItem.Value ) ) & If( CountRows( Filter( TSGResponses, TSGActive = 'TSGActive (TSGResponses)'.Yes, dbam_gametitle = ThisItem.Value ) ) = 1, " response", " responses" )