Format number

[sianastaso]

Hi I have the following question:

I have a dataset with shops that are displayed as: new and closed. 

The total number of shops is 150 and the closed ones are 80. 

Can I display the number 80 with " - " in front? 

[davidskaife · Accepted solution]

Hi @sianastaso 

EDIT - i've made this FAR more complicated than it needs to be haha, you can simply do this instead:

Yes you can, just use the formula below in a Formula tool and apply to the existing Closed field (this assumes the field data type is a number already):

tonumber('-'+tostring([Closed]))

[Felipe_Ribeir0]

Hi @sianastaso 

You can multiply the Closed column by -1.