I currently have a value in one of my columns which reads: -2.1884462822743185E7
I am trying to get it into the format: -21884462.82
I have seen that I'm not the only user to have this problem, and other users have been recommended to use the formula:
However, this only works in the sample output next to the formula box, and not in the actual output.
By default, DSS will display numbers in scientific notation above a certain threshold and unfortunately this is not configurable.
If you do need to keep the value, your workaround would be to multiply this column by 10 and apply the formula below(3f instead of 2f).
Instead of applying formula, you can also use round number processor in the Prepare recipe.
Another (less recommended than above) workaround would be to store this column in a string format.