[RESOLVED] Using count in formula feild

[sanju4kk]

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

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

[ConfusedAgain]

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.

[sanju4kk]

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

[ConfusedAgain]

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

[sanju4kk]

how will it work?

[ConfusedAgain]

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