Negative number format

[guya]

All,

I would like to display negative number in brackets and red if possible in a pivot or straight table.

Is this possible?

With many thanks,

Guy

[#2]

Hi

Use someting like this as expression:

=if(YourValue<0,'(' & YourValue & ')', YourValue)

Replace YourValue with your value... tell me about it

The color can be done in the "Visual Cues".
Beware: Adding brackets changes the Number Format to a Text Format and the Visual Cue "<= 0" wont work for formatting it red!

Greets

[#3]

Hi,

sorry but no wou won't do that with an if.

Go to the Properties of the chart, then to tab "Number", point to the Formula you would change, choose a format i.e. "fixed to 2 decimals" the format pattern shows #.##0,00. Then you add ";(#.##0,00)" to that pattern. The pattern after the ";" is for negative values.

For the colour, you go to tab "Visual Cues" and point again to the Formula you would change and write a 0 (zero) in the input box after "lower <=". Then choose a colour and say O.K.

Have Fun with QV

Alex:)

[guya]

Thanks for your prompt reply.

Alex, the final format looks like this #,##0.00;(#,##0.00) and works fine - Thx. I tried the same for percentage result but with no success.

I used this format #,##0.00%;(#,##0.00%) and the result changed. e.g the number -21.86% becomes (0.22%).

Any idea?

Guy

[#5]

This happens, in my example, when the decimal/Thousand seperator in the pattern differs from the separators in the pattern.But I'm not shure about that.

Alex:)

[#6 · Accepted solution]

Oops that was wrong,

try: #.##0,0%;(#.##0,0)%

Have Fun with QV

Alex:)

[guya]

It works fine!

Thanks a lot.

Guy

[#8]

Hi

Sorry for commenting on an old post.

I am trying to show minus brackets on Gauge chart but it only converts the value to (1.0)% rather than (100)%. I have used the formating: #.##0,0%;(#.##0,0)%.

And the negative formating works fine on straight table but not on Gauges

Can you please help..

regards

Buti

[vijay_iitkgp]

Hi,

one work around. Go to Chart Properties---> Number. Check Integer and then check show value in %. after that uncheck integer and check money. you will get desired result.

[#10]

Hi Vijay

Stil not getting the desired results.

regards