Debugging your spreadsheets
It is common that Dashboard Design developers may accidently put in the incorrect formula when developing logic on their spreadsheets. Using the Ctrl +` hotkey will make things much easier.
How to do it...
- Select the worksheet you want to see formulas for.
- Hit the Ctrl key and ` (grave accent) key together.
- You will see the value in the cell change to the formula.
How it works...
The hotkey Ctrl+` works by showing the underlying formula of a cell. This is extremely useful if you are comparing formulas from multiple cells, the reason being that the developer does not have to flip between formulas in order to see what they are doing wrong when comparing multiple cells. Developers can quickly analyze their worksheet and ...
Get SAP BusinessObjects Dashboards 4.0 Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
