Basic pivot table with a basic DP report. Trying to use a calculated field to count total entries by day and how many were flagged as YES. The answer would be 17 entries, 4 Yes. The calculation field will only count total entries (17) for a formula that is supposed to only count value = "Yes" (4). Formula verifies correctly. Of note, same results using regular report.

Report formula setup and returned results:

SELECT COUNT (Call_No) FROM Count_treated_by_date SELECT COUNT (Call_No) FROM Count_treated_by_date WHERE Tx_yes='Yes'

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.

## Question

## roattw

Basic pivot table with a basic DP report. Trying to use a calculated field to count total entries by day and how many were flagged as YES. The answer would be 17 entries, 4 Yes. The calculation field will only count total entries (17) for a formula that is supposed to only count value = "Yes" (4). Formula verifies correctly. Of note, same results using regular report.

Report formula setup and returned results:SELECT COUNT (Call_No) FROM Count_treated_by_date SELECT COUNT (Call_No) FROM Count_treated_by_date WHERE Tx_yes='Yes'

As always, all help is appreciated!

## Link to comment

## Share on other sites

## 2 answers to this question

## Recommended Posts

## Join the conversation

Note:Your post will require moderator approval before it will be visible.