Add Number Format and add Override Decimal Precision in a Grid Report

White Cup BI allows you to add number formats (dollars, percent, and commas), and override the decimal display precision on grid style reports. These features are available for standard and calculated columns.

Both features are accessed by clicking on the column header when viewing a report, and selecting the option “Format”.

Number of Displayed Decimal Places

This option gives you a range from zero to four decimal places.  Select the number of decimal places you want to have displayed from the drop down menu.

Format

This option allows you to display additional formatting to the values in the column.  Your choices are to add a dollar sign, a percent sign, the number without commas, or the number with commas.  If no choice is selected, White Cup BI will use the default formatting in the column definition.

At this time, the options available are limited to these choices.  If you have a need for further decimal precision or different types of formatting, please reach out to our support team.  They will be able to send your request to the development team for possible inclusion in a future release.