Am trying to write a formula for counting the SETUP type but looks like am having trouble. I have a field called SETUP Type having 2 values 'MANUAL' and 'ELECTRONIC'. How would i get the count for each manual and electronic at the report footer?

 

I have 2 formuals created

If {Command.SETUP_TYPE} = 'ELECTRONIC' then count({Command.SETUP_TYPE})

and

If {Command.SETUP_TYPE} = 'MANUAL' then count({Command.SETUP_TYPE})

 

but its not giving the correct count. Any ideas?

 

Thanks