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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.