Skip to Content
0
Former Member
Jul 21, 2008 at 02:52 PM

Calculating No of records in query level

19 Views

Hi Friends

I have a characterictics Missed order, which can hold value either Y or N,

What i need is ,for eg: if we have 10 records where 6 Y's and 4 N's .

I need to calculate 6/10*100 , so answer is 60%.

Basically, *( Total no of 'Y' records / Total no of records * 100 ).*The no of records and no of 'Y' records are not fixed, it depends on the data load.

So , how to calculate the percentage and to display in report?