Forum Discussion

Ophir_Buchman's avatar
Ophir_Buchman
Data Integration
03-07-2022

Pivot 2.0 - Replace the "-" Sign of a Negative Value by Parentheses

In Accounting, it is common to represent negative numbers with leading and trailing parentheses. For example, negative two hundred is displayed as "(200)" To change a negative number formatting i...
dashboards & reporting
Finance Analytics
magic_mic's avatar
magic_mic
Data Storage
10-03-2023

I have used the script to replace "-" with () for negative values. But it causes the values in the pivot table not refreshing properly in my dashboard when I switched the filters from one to another in my dropdown option.