Hello @steven_bradburn,
In Javascript the scientific notation corresponding to 650,000,000 would be: 6.5e+8 and can be gotten using the toExponential operation as follows:
Number(650000000).toExponential()
However, you can manage the result as a string to replace e+ with X10^ an get the result in the format you want.
Number(650000000).toExponential().replace('e+', 'X10^')
and that’s all, the result would be: 6.5X10^8
Best regards.
Hello, Many thanks for the quick reply. Where do I enter the code, would this be in the ‘Set equation’ box? Thanks
Hello @steven_bradburn,
Yes, the code should be entered as part of the equation into the attribute: “Set Equation” in the settings of the calculated field.
For example, if your current equation is: fieldname1+fieldname2, it can be edited as:
Number(fieldname1+fieldname2).toExponential().replace('e+', 'X10^')
Best regards.