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)?
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events