Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Count on a selected data in column

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

Tags:
Former Member
replied

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

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question