The filter dialog for percent formatted line items should display a % after the filter value

When you're entering values in percent formatted cells, unless there is a % in the cell, the value entered should be a decimal to show the correct value, e.g. 0.5 should be entered to display 50%. 


When setting up a filter on a percent formatted line item the value to filter on does not have a % therefore I would assume I should enter a decimal value. This will not generate the correct results, I would actually have to enter 50 to filter on 50%.


It would be beneficial to users if the filter dialog included a "%" after the filter value cell to indicate to users that they should be entering whole numbers, not decimals.



1 votes

New · Last Updated


  • Status changed to: New
  • Agree, It should have some indication that % is expected where it is % number formatted. We need the same feature for Quick Filters also.

Get Started with Idea Exchange

See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!