We help IT Professionals succeed at work.

Business Objects count value

Pdeters
Pdeters asked
on
I am creatnig a webi report in Business Objects.  I have a field that has either Yes or No as a value. I want to count if just yes
Comment
Watch Question

Commented:
if it is a string value, then it is select count(*) from <table> where field = 'Yes'
if it is a boolean value the it is select count(*) from <table> where field = true

Author

Commented:
this is a Business Objects webi reoport
Commented:
here is the answer

=Sum(If([[EmpStatus] = "Yes"; 1))

Author

Commented:
found my own answer