For some reason I am having difficulty getting the data formatted the way I need it.
in datamapper - I have it set to ‘float’ - I have this because I am also graphing the data
in template - the zero drops off at end of data ( ex. 5750.50 is returned 5750.5)
I do not want the currency symbol. I have tried this setting but it adds parenthesis when it is a negative number. I need to have the negative sign ( ex. -5750.50)
I used toFixed(2) to get the zeros but I can not get the comma added.
Data examples -
Mapper Template Need
-5750.5 -5750.5 -5,750.50
37860.60 37860.6 37,860.60
Any ideas as to why I am having difficulty?