How to add +, - and +/- in number formating?

[peterstalberg]

Hi,

I have a table with positiv, negative and 0 values (Input). I would like to format them as Output in the table.

The formula num([Input], '+# ##0;-# ##0;+/-0')  works for positive and 0 values but not for negative values as per Error in the table.  What is wrong here? RGDS//Peter

Input	Output	Error
5 000	+5 000	+5 000
0	+/-0	+/-0
-5 000	-5 000	-+5 000

[vinieme12 · Accepted solution]

as below

num(Input,if(Input=0,'+/-#,###','+#,###;-#,###'))  as formattedInput

[peterstalberg]

Thank you for the help! This works but I'm still puzzled why my proposal num([Input], '+# ##0;-# ##0;+/-0') doesn't do the trick....?!?

[vinieme12]

num() only accepts 2 params

1st - the value to be formatted

2nd -  ' <format for +ve values> ;   <format for -ve values> '

in your expression, you are trying to specify formats for 3 values(+ve,-ve and 0)  which is not possible