Count on a selected data in column

[Former Member]

Hi,

I have column in which the data is like either 'Y' or 'N'. Now I want to put summary field at the end only for 'Y'. i.e. how many 'Y's in the column.

Please help me how can I do this.

- Aravind

[abhilash_kumar · Accepted solution]

Hi Aravind,

1) Create a formula with this code:

IF {field} = 'Y' then 1

2) Go to Insert Summary > Choose the above formula field as the 'Field to Summarize' > Choose 'Sum' > Place the summary on the Report Footer.

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash,

Thank you so much. I have one doubt on this, is there anyway that to get the count of 'Y's without adding formula field into report?

[abhilash_kumar · Accepted solution]

Can't be done without a formula. You can add a 'Running Total' field however, that will also need a formula in the 'Evaluate' section.

-Abhilash

[Former Member · Accepted solution]

Aravind,

Abhilash suggested the above same way to do this:

You restrict the column 'Y' only in selection formulas -> Record.

Go to Insert Summary > Choose the above formula field as the 'Field to Summarize' > Choose 'Count' > Place the summary on the Report Footer.

Thanks,

DJ

[abhilash_kumar · Accepted solution]

Sorry DJ, but 'Count' is incorrect. Count will return the count of Ys and Ns which is not what Aravind is looking for.

-Abhilash