Jump to content
  • 0

COUNT or tally Yes / No fields in Totals/Aggregates


roattw
 Share

Question

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"

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

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

Link to comment
Share on other sites

  • 0

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?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...