COUNT or tally Yes / No fields in Totals/Aggregates

[roattw]

Its been asked before but no complete resolutions for that eask it seems.

The offered solution was Select COUNT (Yes/Nofield) from tablename WHERE YesNo=1

I have a very basic Yes/No field for attending an event. (Attending)

The formula I am using passes the Verify test.  But when I preview it it says "This DataPage uses parameters. To simulate this DataPage with parameters, enter values below."  Entering a value or leaving empty it concludes with "Error in Formula"

 

Using this formula: 

SELECT Count([@Attending]) FROM tbl_mytablename WHERE [@field:Attending]="1"

[CoopperBackpack]

On 1/24/2020 at 10:50 PM, roattw said:

Its been asked before but no complete resolutions for that eask it seems.

The offered solution was Select COUNT (Yes/Nofield) from tablename WHERE YesNo=1

I have a very basic Yes/No field for attending an event. (Attending)

The formula I am using passes the Verify test.  But when I preview it it says "This DataPage uses parameters. To simulate this DataPage with parameters, enter values below."  Entering a value or leaving empty it concludes with "Error in Formula"

 

Using this formula: 

SELECT Count([@Attending]) FROM tbl_mytablename WHERE [@field:Attending]="1"

Hello @roattw,

In the formula, in the Count function the parameter name is used now: [@Attending].

Please, try to use the field name, not the parameter name.

So, the formula should be the following:

SELECT Count([@field:Attending]) FROM tbl_mytablename WHERE [@field:Attending]="1"

I hope this helps.

[Corpcatalog]

I used the following in my table 

SELECT Count([@field:SubscriptionComplete]) FROM 
GrowerSubscription WHERE [@field:SubscriptionComplete]="1"

However that returns the total for all records in the table. My report is filtered by the managers name, how can I show only the tally for the results for the filtered table?

[AtayBalunbalunan]

You need to add another condition, Corpcatalog. It will depend on how you filter it. If you have a default value, the formula would look like this:

SELECT Count(SubscriptionComplete) FROM GrowerSubscription WHERE SubscriptionComplete="1" AND Manager="CorpCatalog"