Is there a way to move the '-' symbol to the left of the dollar sign for 'Price' types?
Solved! Go to Solution.
Thanks for the responses! I was able to achieve it by using a strategy similar to what @graham_howe proposed, a virtual text column with the following formula:
CONCATENATE(
IF(
[price_field] < 0,
'-',
''
),
TEXT(
ABS([price_field])
)
)
The dollar signs still came through so I just needed the minus sign in the IF().
Unfortunately there is no easy way to format prices the way you would like. There is the option to using accounting format (it's at the bottom of UX options) but I think that uses parenthesis rather than a minus sign.
Perhaps copying the absolute value in another column and using it for display.
Actually that's not a bad idea, a VC with something like the following would work,
concatenate(
if(
[price_field] < 0,
"-$",
"$"
),
text(
abs([price_field])
)
)
Yes, and to control the display of both columns through their Show fields:
__
Why the IF()? I think the goal is to remove the minus sign always.
The goal was to have the minus sign to the left of the dollar sign for negative numbers.
I need to sleep ๐ด ๐
Thanks for the responses! I was able to achieve it by using a strategy similar to what @graham_howe proposed, a virtual text column with the following formula:
CONCATENATE(
IF(
[price_field] < 0,
'-',
''
),
TEXT(
ABS([price_field])
)
)
The dollar signs still came through so I just needed the minus sign in the IF().
User | Count |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |