Negative Zero

[Anonymous]

In a staright chart, the expression default is:

-0.0004699869

I selected, Fixed To 1 Decimal and Show in Percent (%) under Number tab

and it becomes:

-0.0%

Is it possible that after this number formatting, if the result is 0, it shows up as:

0% in chart ?

[Gysbert_Wassenaar]

Yes, specify a format pattern that includes a format to display negative numbers without the - sign. For example #.0;#.0

[nagaiank]

Use Floor(Fabs(expression))

[swuehl]

You probably want to show larger negative numbers still with a minus sign and with 1 decimal.

You can specify the format in your expression, leaving the numbers tab option on expression default, something like

=if(fabs(VALUE)<5E2, num(0 ,'0%'), num(VALUE ,'0,0%') )

[Anonymous]

Thank you all for your reponses.