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?