I've got a 2010 SP list that tracks tickets about an application I own. It tracks various ticket attributes including'status' and 'type'. I want to create a view of 'open' tickets for my developers based on the value of 'status' and/or 'type'. There are enough options for these fields that I've run out of filter options on the view. So, I've added a calculated-column, boolean field, call it 'DevOpen', to the InfoPath form. I've written a formula to determine this fields value as follows;
not((Status = "A") or (Status = "B") or (Type = "1"))
where the bold text are inserted fields and status A and B and type 1 are associated with 'closed' tickets.
When I open the form, the value of the Boolean field value is correct...either true or false...according to the formula.
My problems are two-fold. First when I add this new field to a view, the values are wrong. There are several variants; the InfoPath form properly shows 'true' but the view shows 'No', the InfoPath form rightly shows 'false' and the view shows nothing/blank, or the InfoPath form shows 'true' and view shows nothing/blank.
Secondly and likely related to the first point, when I try to use this new field to filter a view it doesn't work. Again, I'm trying to get a view of open tickets. I've tried all variants of the filter criteria (Yes/yes/true/True/etc. and No/no/False/false/etc.). Nothing seems to work properly although if I set the 'DevOpen' field filter to 'No' I do get tickets shown but they're not the ones I want. I want DevOpen=true/yes tickets to be shown.
What am I doing wrong?