Text() function.
I have column with price type.
This column is quoted and used in virtual columns in combination of other column to show new values.
To show $ as it is price, I use Text() function.
However, when the price is minus, it is show as ($xx,xxxx), instead of “-$xx,xxx”.
How can we show price value as " -$xx,xxx " in such a case?
#ERROR!
User | Count |
---|---|
43 | |
29 | |
23 | |
20 | |
13 |