Counting formula in crystal crosstab

[aftab45]

Hi All,

I have a problem with counting in a crosstab. To illustrate, here is a an example:

Field1 Field2
ABC Yes
null
ABC Yes
DEF No

Field2 uses a formula which says:

If Field1 startsWith "ABC" Then Yes Else No

I'm trying to construct a crosstab where one of the columns counts Field2 where the value is "Yes". This uses a formula which says:

Field2="Yes"

However, instead of returning 2, it returns 4.

Is there anything I can do to get an accurate count?

Thanks in advance.

 

[IdoMillet]

Use a formula that returns 1 or zero.

SUM (not count!) that formula in the CrossTab.

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com