Download: negativesFormatter.zip
Introduction
This article explains how to adjust Pivot tables and indicators to use standard financial formatting of numbers. This means showing negative numbers as always RED with parentheses instead of a minus sign, as well as populating empty (null) cells with 0 values.
Before using this plugin:
After applying this plugin:
Steps
The following steps will walk through the process of adding the new chart type and creating a sample funnel chart.
STEP 1 - ADD THE PLUGIN
Download the attachment and unzip the contents into your C:\Program Files\Sisense\PrismWeb\plugins\ folder. If you are using version 7.2 and higher unzip the contents into your C:\Program Files\Sisense\app\plugins\ folder. If the plugins folder doesn't exist, just create it. After those files have been unzipped there, you may also have to restart the web server. Now when you create or edit pivot or indicator widgets, you should have additional setting options
STEP 2 - CREATE THE CHART
On your dashboard, edit or create a new pivot table or indicator and click on the settings menu at the top right of the screen. You should see some new options under Financial Formatting that allow you to decide on if you want negative values to be formatted this way and if you want to replace empty cells with zeros.
References/Notes
- This plugin was developed for just pivot tables and indicator widgets
- The negative formatting is set to only be applied to percentages and currency values, regular numbers will be ignored by this plugin
