cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
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
Version history
Last update:
‎03-02-2023 09:41 AM
Updated by:
Contributors
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

Sisense Privacy Policy