New answers tagged grid
Where budget is zero and actuals is zero then the difference (delta) should be zero! There is no difference between 0 and 0. Where budget is zero and actuals is high then the difference (delta) I think it looks great by stating 'Infinity %'. It is truthful, concise, meaningful, elegant, non-symbolic, not cryptic. Good framework, have a biscuit! Where ...
Consider using Master Detail layout. When the user clicks on a row in the LOVs list (Master) the details are displayed in a sperate list (Detail). You can have both lists in the same window either top/bottom or Left/Right. download bmml source – Wireframes created with Balsamiq Mockups
My opinon is that the new button should be at the end of the list. This will also force your users to look through the list before adding, and maybe this is something you want them to do e.g. avoid duplicate links. Consider also adding a button that will take you at the end of the list.
You need to think about the user flow here. What's being added? Is it common to add something, then, immediately after that you interact with it? Or is this just for the sake of adding new elements? Also, design wise, think about scalability. What happens when that list gets really REALLY long? Does the user have to scroll all the way to the bottom to add ...
Why not both? Have it consistently placed at the beginning of the list (top left). Add new items to the beginning of the list (slide the others along/down). This also keeps the newest items more visible (at the beginning of the list), and older items less visible (towards the end) - which may be preferable, depending on what your use case is.
Is this really a choice between just two options? I think there are more solutions than presented. Maybe it's better not to include the functionality for editing the list in the list itself. This way there is a clear distinction between content and functionality. One option would be to place to the button in the upper right corner. This is, for example, how ...
Here's the actual issue with this: If you don't put it at the top left, it'll always be in a different position, and thus be less easy to locate for a user. This is without even taking into account pagination. What are you going to do if there are 10 pages? Stick it on the last page? Stick it on every page?
If the latest item will appear on the top, then add the "add button" on the top left. If the latest item will appear at the bottom, then I would recommend adding the "add button" at the bottom. You guys might also want to consider adding a wide add button, that spans across 3 columns, at the top. That way it'll be quickly visible to the user.
From a user perspective, I would prefer a blank cell, if it is clear that this cell is computed by dividing Budget by actual. Background: Adding a long text adds a lot of noise to the grid, especially when no budgets are frequent. You might add a tooltip like excels blue green info mark, which shows "could not be computed, because the budget is zero"), but ...
Why can't you demo it to some of your users, and ask them to say what they think? They are two different situations though, and a N/A may be confusing. Infinity is right for x/0 so long as x is not 0. Look at the graph of 1/x. As it gets closer to 0, the group explodes to infinity. As a limiting value, 0/0 is indeterminate meaning it can be anything. ...
A list can be displayed as in figure 1. When there are more than 5 items, you could add the link "more" clicking on which would show the next 5 items as in figure 2. download bmml source – Wireframes created with Balsamiq Mockups Further, if the items tend to go beyond 10 items, you could give a search option as in figure 3, within the list ...
I would provide the values as you have in your screenshot if there are sufficiently few, but if there are too many, show the first one or two with a "and n others". In that case, make it both clickable (as you have in your screenshot) and perhaps include a [+] icon just prior that would expand an indented/child row below that row with a grid with all the LOV ...
I would use some small-styled text saying "DIV0" or "INF" / "∞", in a gray shaded box background with some negative space around that. It should look like an icon to show it's not a typed or calculated value like the rest. But the message can still be read clearly so that the relevance of the problem is apparent without having to understand some generic ...
You could use an exclamation mark icon that shows a tooltip on hover to explain exactly, what it means and what is missing / what value is bad: download bmml source – Wireframes created with Balsamiq Mockups
Either: Give a cause - a couple of words stating why the calculation cannot be made. Use an error string - as other have mentioned, take examples from Google sheets and Excel. Check the result - when you do the calculation, if the result is NaN or Infinity, display N/A instead. Add a help link - a small '(why?)' or '(learn more)' next to the error that ...
A common solution for table cells that are not available or applicable in certain situations (such as your %Δ for a budget of 0) is to use the placeholder text n/a (or N/A).
Most spreadsheets (OpenOffice Calc, Microsoft Office Excel, and Google Spreadsheet) will handle these cases displaying a non-blocking error akin to "division by zero": I think this is the best behaviour, because it does fill the field with something meaningful to the user, but at the same time it doesn't "stand out" too much and compromise the overall ...
You might consider having a word with the users and ask what they think they should see, though be careful, their initial reaction might be 'zero', which is DEFINITELY not right in any mathematical sense. I personally would leave the output blank, or perhaps use the term 'undefined'. If they really want to see a symbol, then I think you could safely put the ...
You could try to use a short description of the actual cause, e.g. no budget
Top 50 recent answers are included