The BI Answers in PivotTable typically display an empty cell in the event that there is no value for the combination of rows and columns.But what if you want to display instead of the empty cell value of zero (0) or something else, such as N / A or "----"? In this case, can be used to define custom formatting numbers. For basic formatting of numbers can be used either predefined formats or use your own format. The syntax for a custom number format is: Number sign (#) to include significant numbers and the number zero (0) for include a specified number of digits, even if the number does not include this detail. If you enter a string such as #. # 12.34 number is displayed as 12.3. If you enter a string # .000, displays the number 12.34 as 12.340. You can also use more complex formatting with HTML: The first character must be specified at sign (@). This allows devices that do not display data in a modified format, see the data in the appropriate format by default. Text [html] means using HTML and the at sign (@) is a dynamic content columns, viz. figure below.semicolon separated format can be positive numbers (including zero), format negative numbers, and format blanks or NULL values. Sample number formatting and NULL values: The advantage is that such a format can be saved as the default for the Presentation object.
Posts
