Your query isn't 100% clear to me, but from what I can gather you should be able to achieve what you want if you create a running total set to count, and apply the condition:
UCase({F6}) in ["TEXT1","TEXT2"]
what about using a global variable to count the matching entries?
Supposing that your formula is placed in the detail-section of your report you could modify it like this:
global numbervar counter;
whileprintingrecords;
if ({F6}= "TEXT1" or {F6}="TEXT2" then counter:=counter+1;
I'll name this formula {@inc}.
Then create a second formula (which contains the total) that is likely to be placed in the report footer. It should look like this:
global numbervar counter;
evaluateafter({@inc});
counter;
That should do the trick. When working with groups, the solution may vary but the idea should be about the same.
thanks for your help. The suggestion of Naith is great.
It work's fine. But just in the details section. When I put the runningtotal field in the report header, the value is 0.
Your questions:
Sorry, the values are "text1" and "text2".
I don't want to count null values.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.