Exponent Problem

[claudepatry]

In Impromptu when I divide two numbers, I have a result with an exponent at the end. For example, 4.79 / 122.6381 gets me 3.905740e-002. How do I get the expected result of 0.0390574? In SQL there's the CAST function but it doesn't work in Impromptu. PLEASE HELP!!! Thank you.

 

[drlex]

Don't fret - it's just a display issue.
Right-click the field, choose 'Format' from the contextual menu and then select the required numeric type - probably 0.00. Add on the number of zeros on the RHS to give you the decimal places required.

soi là, soi carré