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

(tsuji koichi) #1

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?

(Aleksi Alkio) #2

#ERROR!