Plus sign

[jonhowald]

Is there a way to add a plus sign to the data if the value is greater than 0?  For example, I would like to display the data as:

+3

+10

+9

-3

Thanks!

[JosephSerpis]

Hi @jonhowald its possible however in alteryx you would need to create a string field and convert your numeric data into a string. The reason being is you cannot add a plus sign to a numeric field. I've mocked up a workflow to showcase how to do this.

[jonhowald]

Thanks!!  That helped.  

[pedrodrfaria]

Hi @jonhowald 

Just be aware that by adding the + sign you have changed the field from a double to a string, so you won't be able to do any additional calculations using this field as a numeric value. I would recommend you to do this as a final step before outputting.

Pedro.