Count or sum text field

[rbvcbr]

I have a formula field which returns 0 or 1,
I want to count how many 0s and how many 1s.
I formatted this field as numaric. Then I try
right clicking on this field it gives me 'move'
instead 'Insert/grand total or summary"
Can some help how to do this.
Thanks in advance

 

[lbass]

Please show the content of the formula.

-LB

 

[rbvcbr]

if {@sex} = "Female" then 0 else 1

 

[lbass]

When asked to show the content of a formula, you should always show the content of nested formulas as well. You have added something to one of the formulas that makes it unavailable for an inserted summary. So please show the content of {@sex}.

Also, if you have placed this formula in a text box, remove it and place the formula directly in the detail section.

-LB

 

[rbvcbr]

Sorry to drag this, yes, I did inserted the formula in
detail section,not in a text box.

The Other questions @sex comes from different kind of formulas, it is hard put it here.

Thank you,

 

[lbass]

You must put it here or I can't help. Unless you happen to be prefacing your formula with an unnecessary whileprintingrecords which you can simply remove.

-LB

 

[Madawc]

rbvcbr, you mgiht do better to begin again with a Running Total. Have an evaluation formula like

{@sex} <> "Female"

If you're not already familiar with Crystal's automated totals, see FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10