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!
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.
Thanks!! That helped.
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.