Showing results for 
Search instead for 
Did you mean: 
Community Team Member
Community Team Member
By default SiSense formats negative numbers by using the minus sign, like -1500. Some people prefer to format negative numbers by using a parenthese, like (1500). This article shows how to edit a widget's script to format the numbers this way.
The following screenshot shows how the widget was initially formatted.
There's one line that you may need to edit in order to get it to work in your environment.  The '2' in _.each($('td:nth-child(2) div' , e) refers to the column of the pivot chart that we are trying to format. Change this to the appropriate column number.
Here's a widget script:
widget.on('ready', function(se, ev){
 var e = element;
 var w = widget;
 var d = dashboard;
 var s='td:nth-child(X) div'
 for (i = 2; i < 15; i++) { 
   _.each($(s.replace("X",i.toString()) , e).not('.wrapper, .p-head-content'), function(cell){ 
   var num =  parseFloat($(cell).text()); 
   var negative = $(cell).text().replace("-","");
   if (num < 0) {
    $(cell).text('('+negative+')' );
After applying the changes to script, reload the widget, and you should be able to see the changes. Here's a screenshot of the results.
Version history
Last update:
‎03-02-2023 09:10 AM
Updated by:
Community Toolbox

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

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: