Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Ive got a couple of numbers ranging from 0.1 to 0.00001 in a excel-file. They are not formatted as numbers (due to the range).
I dont want the numbers to with a fixed format (0.10000 to 0.00001).
How can I deal with this in QW?
It works now with 4 decimals but with 5 it shows 4,6e-005 (0.00046).
Thanks in advance!
Hi!
use NUM() Function.
=Num(Fieldname)
Hope this helps.
Hi,
Try this.
Num(Field_Name,'#,##0.0000000000')
This will allow you to show 10 digits after decimal point.
Regards,
Kaushik Solanki
Forgot to say that Ive tested both Num() and Num# but both generates a error when I load.
Not sure of the english translation but something about "Trash-code after section".
the line looks like this;
Result as Num(GVResult),
the same with Solanki's tips...
Use:
Num(Result) as GVResult,
duh, ofcourse..
Still doesnt help all the way tho.
With just the Num(Result) as GVResult I got no change at all
With the formatting I just gets ##### instead of numbers...
Hi,
If you are using this in Script then you must use in this fasion.
Num(Field_Name,'#,##0.0000000000') as Field_Name
If you want to use in dimension then just use.
Num(Field_Name,'#,##0.0000000000')
If you want to use in chart then you must go to properties-> number -> and click on expression and click on Fixed to . Here type 10.
Regards,
Kaushik Solanki
can u upload ur application.
Solanki: I tried both and if I just Fixed to All the numbers got 10 decimals (I only want the ones that needs it to have 10 decimals)
Gupta: Sorry, dont think it would help since its not in english
But its strange that there seem to be a limit with 5 decimals...4 shows OK even without Num()-function.
i want to knw where r u using this field.
if u r using it in pivot or straight table then expand the column containing this field.....becz #### is normally shown when the number contains many digits and thy don't fit in the column.so Expand ur column.