[RESOLVED] Using count in formula feild

I wanted to sort out the count of males from the table tembcustbl abd the following are the formula i have created

Code:

---

if {TempCusTbl.CF_PREFIX}='Mr.' then
Count({TempCusTbl.CF_SEX})
else
0

---

but its not showing any result..there is data in the table..
please help me

Can you change your formula to

if {TempCusTbl.CF_PREFIX}='Mr.' then
1
else
0

And then sum that field. This will give you the count.

I want to count the total people who having title 'Mr.' ..

What is it that does not work with what I put?

how will it work?

Create a conditional formula: Use the formula as above below is just to provide explanation for it

If the field = Mr Then Value = 1
Else Value = 0

You then need to Sum the formula at the Report total or group total where ever it is you want to count the number of Mr.

So example
Field
Mr = 1
Miss = 0
Mr = 1

Does that make sense?
Sum that and you get a count of Mr = 2