Jump to content
  • 0
Sign in to follow this  
roattw

COUNT or tally Yes / No fields in Totals/Aggregates

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"

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
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...
Sign in to follow this  

×
×
  • Create New...