Click to See Complete Forum and Search --> : Counting filtered fields


ezzy85
April 28th, 2006, 01:07 AM
I have a field for the number of items. I need to count how many of these items contain the word "hello" and I need to express this as a percentage of the total number of items. What would be the best way to do this?
Thanks

sraheem
April 28th, 2006, 02:11 AM
whileprintingrecords;
numbervar a;
if field='hello' then
a:=a+1


i haven't tested it, give it try...

good luck