Formatting Negative Values

[dmpope]

Hi all,

The reports that I use have the negative values formatted with the minus sign at the end of the number rather than at the beginning, which causes an issue when I try to change the amount columns from a v_string to a FixedDecimal. Is there a tool or a formula I can use to move the minus sign to the beginning of the numbers so that Alteryx will reconize those amounts as a negative number? I've attached a snippet of a couple negative amounts in my report as an example.

Thank you!

[echuong1 · Accepted solution]

You can use a conditional statement to look for a negative symbol. If it sees a negative, it concatenates a minus to the beginning, and trims the last character (minus symbol). A Select converts the value to a number.

[DylanDowrick]

Here is a multi-field formula which may help!