Count of string

[Former Member]

Hi All,

I have a  field carton no which is string type.The values are 1 and 2.

I gave summary as count for that in report footer .But it is showing 32 .But it should show 2 only.

Here the report having 32 records .I tried with changing string to number also

Please help.

[abhilash_kumar · Accepted solution]

Hi Divya,

Are there any blank rows that you have suppressed? I see 32 records at the bottom which is what Count will show too.

Try this:

1) Create a formula with this code:

if {Carton} <> "" then 1

In the formula editor window, look for an option on the top that says 'Exeptions for Nulls', change that to 'Default Values for Nulls'.

2) Insert a Summary on this formula field and place it on the Report Footer. Use 'Sum' as the summary operation.

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash,

I don't have any suppressed rows.

I tried with your solution but not working.Still i am getting 32

[abhilash_kumar · Accepted solution]

Go to File > Report options > check the two Null options on the top.

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash,

I tried but not getting

[abhilash_kumar · Accepted solution]

What is on the first page?

How many groups are there? Does each group have the same carton nos.?

Use 'Distinct Count' as the Summary operation instead.

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash,

I have group on Carton Number only.Each group have diff carton values.I tried with distinct count but i am getting value as 1.

[abhilash_kumar · Accepted solution]

Go to Insert Summary > Choose Carton No. field as the Field to Summarize > Choose 'Distinct Count' as the Summary Operation > Place the summary on the Report Footer.

-Abhilash

[Former Member]

Hi,

Try Distinct count in Formula.

This option is shown as below in Crystal Enterprise .