Column Converting prefix and suffix

[danjohnsonM]

Hi

I am looking to build a report in alteryx

I want to be able to put a formula in the table that converts the columns into the correct format below, the problem i have is that some rows have K in them and some have % after, also i know you can do the red by selecting if below 0 but how would i take away the - sign that alteryx produces and add the brackets?

I have attached a workflow any help would be greatly appreciated 

[afv2688]

Hello @danjohnsonM,

If I understand this well you want to put the negative number into a more financial format.

Would this help?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[danjohnsonM]

Hi

yes this helps but im also looking mainly to do the % and K in the row rule

Regards Dan

[afv2688 · Accepted solution]

Hello @danjohnsonM,

Would this help you?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards