We use custom fields such as Progress(WBSGantt). if I enter a query project = "OCSS Active Work Streams" AND status = "To Do", it works fine, but when I then add the custom field such as project = "OCSS Active Work Streams" AND status = "To Do" AND "Progress (WBSGantt)" = 100, I get no data, but if I export just the project to Excel and create pivot table using the criteria of ToDo and 100 I get one entry, any suggestions?
And part 2, Progress(WBSGantt) != 0 works fine, but I don't get the 100 entry, but I do get various none whole numbers results. Is there a way to only pull whole numbers in the progress column that aren't 0 (zero)?
Thanks
