scientific notation

[#1]

Hi all,

Hope that all are well.

Things have been going well.

I have run into one problem.

I am performing a computation as part of my load that is resulting in scientific notation i.e. 2.81109796934533e-008.

I am trying to convert this to a truncated numeric expression i.e. 2.811.

I have tried a number of things using the Num function:

- (Num(PT/AVL)/(DYSX * 365)),'(dec)')

- (Num(PT/AVL)/(DYSX * 365)),'##.##')

and no change.

Please help.

Thanks,

Mitch

[sunny_talwar]

May be like this:

Num#(Left((PT/AVL)/(DYSX * 365), 5)) as FieldName

[ramoncova06]

Num(PT/AVL)/(DYSX * 365),'#,##0.00')

[#4]

It worked and thank you for the quick response

[swuehl]

Do you have always the same exponent?

Or how do you use this truncated number then?

If you have always the same exponent, you can also multiply to get your number in a certain range:

Num( (PT/AVL)/(DYSX * 365)*1E8,'#.000')