I have been encountering an issue in regards to how negative floats have been getting handled. If there is a negative numeric for instance -17.80 within the data, the resulting value will be along the lines of -17.-80. Additionally, if I have something along the lines of -17.08, it will give me the same result (-17.-80, completely removing the zero from the tenths place in resulting Numeric Value).
Is there a way to prevent the negative from being attributed to the anything after the decimal when getting a result from the query?
I have been encountering an issue in regards to how negative floats have been getting handled. If there is a negative numeric for instance -17.80 within the data, the resulting value will be along the lines of -17.-80. Additionally, if I have something along the lines of -17.08, it will give me the same result (-17.-80, completely removing the zero from the tenths place in resulting Numeric Value).
Is there a way to prevent the negative from being attributed to the anything after the decimal when getting a result from the query?