Text() function. I have column with price ty...

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?

0 1 285
1 REPLY 1

#ERROR!

Top Labels in this Space