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