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

JayTurner

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.

 

 

Miran

Status changed to: New

Rashmih

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