Enable parentheses for negative numbers in Smartview

Enable parentheses for negative numbers in Smartview

Joined: May 6th, 2016, 7:05 pm

March 31st, 2017, 2:06 pm #1

Hello everyone -

I realize this isn't a pure Essbase question, but hoping someone can help.

Does anyone know how to change how negative numbers display in Smartview? I'm looking for some sort of global setting. I've tried changing the properties on the Windows server that Smartview runs on, but it doesn't seem to help. Right now, they are displaying as -199.00. Looking to have them display as (199.00).

Many thanks,

Joe
Quote
Like
Share

Joined: January 11th, 2017, 9:26 pm

March 31st, 2017, 3:27 pm #2

You can use Excel Formatting to do this if it's enabled. Just enable it and then use the drop down arrow under "OK" to set it as your default. Then just set your general Excel formatting options to show negative values as wrapped in parentheses.
Quote
Like
Share


Confirmation of reply: