Pivot Tables
BI Publisher does not provide dynamic format masking for summarized data. Because pivot tables display only summarized amounts, they are an exception to dynamic format masking. The default formatting for pivot table amount columns is to display amounts with one decimal place and no separator commas, as shown in this example: 123456.1. This format is not ideal, since large numbers without comma separators are difficult to read, and most currencies do not have one decimal.
To improve readability, JD Edwards has chosen to use a manual decimal mask to display pivot tables within One View reports with two decimal places. For currencies that have something other than one decimal, the One View reports that JD Edwards delivers will display data tables and pivot tables with noticeable differences. For example, zero decimal currencies will display the number 123456 as123,456.00 in a pivot table, and as 123,456 in a data table. If your company uses a currency with other than two decimals, you can easily personalize pivot tables within the delivered One View reports to show the desired decimals by changing the decimal mask.