Minus sign placement in negative prices

[Dillon]

Is there a way to move the '-' symbol to the left of the dollar sign for 'Price' types?

[graham_howe]

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.

[Joseph_Seddik]

Perhaps copying the absolute value in another column and using it for display. 

[graham_howe]

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])
  )
)

[Joseph_Seddik]

Yes, and to control the display of both columns through their Show fields:

• For the original column: [_This] >= 0
• For the new column: [price_field] < 0

__

Why the IF()? I think the goal is to remove the minus sign always. 

[graham_howe]

The goal was to have the minus sign to the left of the dollar sign for negative numbers.

[Joseph_Seddik]

I need to sleep 😴 🙂

[Dillon · Accepted 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().