Hello Gents,
need your help to write a formula for counting records with defined calue in the fileld, e.g. how many records with value "123456" in field {table.field}?
thank you very much for your help!U can.
Create a running total field. Add the field which you want to count. Give "Count" as your type of summary.
In Evaluate option,
select "Use a Formula" option. click X-2 box. Write your formula. Never reset this .
u can get the count what u want.
Hope this work.|||thanks a lot, but which will be formula in my case?|||Just simply enter
{table.fieldname} = "123456"|||thanks for prompt reply, but unfortunatelly it always returns zero...|||If it is string field, use trim function, records may be stored with spaces.
Otherwise it should work if the table contains records for that value|||Doesnt help... When i use simply count({fieldname}) - that returns total fine, but with this restriction it doesnt work...|||Sorry for asking this,
Do you have any records which meet ur condition?
I used lots of running total sums with various conditons. working fine.|||Sure, i have :-)
Actually, this field (string type) is a set of 5 kind of different words (total is ~700). I would like to know how many i have words "123456" for example.|||In addition: when i use running total with evaluation "For each record" - it returns 1. When i set type of summary to maximum - then returns only value, not the sum.|||Make sure
i) Included the exact field name in "Fields to Summarize" box
ii) Type of Summary is count
iii) Evaluate:
Check "Use a formula option" and
write the formula in formula workshop (by clicking X-2)
trim({table.fieldname}) = "123456"
iv) Reset:
check "Never" option|||Yes, all of these conditions is true.|||Ok, good
Now where have u placed your running total field?
(in which section)|||In ReportHeader.|||that's the problem.
It's running total. So will be calculated while printing records.
So place in Report Footer. So u'll get the count.|||Thats works! Thank you very much!!!
No comments:
Post a Comment