Column Converting prefix and suffix

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

Table help.yxmd

Reporting

Accepted answers

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

Table help.yxmd

All comments

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

Table help.yxmd

Hi

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

Regards Dan

Quick Links

Tags

This months top contributors

AkimasaKajitani 387

Hollingsworth 335