Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
as below
num(Input,if(Input=0,'+/-#,###','+#,###;-#,###')) as formattedInput
as below
num(Input,if(Input=0,'+/-#,###','+#,###;-#,###')) as formattedInput
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....?!?
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