Number Formatting in expression level

[Anonymous]

Hi Guru's

I want to Format My output Number Up to 3 Decimals

EX: Num(((5/10/33,'#.##', '.',',' )

5/10/33=0.015

if i use like this Num(((5/10/33,'#.##', '.',',' )

it showing 0.01

So, i need  to show one more  decimal in output

Ans:0.015

thanks in advance

[senpradip007]

Try like:

Num(5/10/33,'#.###', '.',',' )

[tresesco]

Try:

=Num(number, '#,##0.000' )

[Anonymous]

Hello,

try this one:

Num(((5/10/33,'#.###')

[jagan]

Hi Babu,

For 3 digits you have to give 3 zeros after '.'

Num(5/10/33,'#,##0.000')

Regards,

Jagan.

[Anonymous]

Hi Guys ,

I tried all ur Suggestions.It showing 0.005

i need  0.015

I got required number 0.015

explanation: num(num(field1/field2,'0.000')/

                  num((field3)-field4),'0.000),'0.000)

field1=5

field2=10

field3-field4=33

Note:Iam not using environmental variables in applicatio

Thanks guys.

[senpradip007]

Hi Babu,

I've tried and its working fine with Num(5/10/33, '#.###') this expression.

[jagan · Accepted solution]

Hi Babu,

This Num(5/10/33,'#,##0.000') is working as expected and returning 0.015, if you want 0.01 then use Num(5/10/33,'#,##0.00').

Hope this helps you.

Regards,

Jagan.

[jagan]

Hi Babu,

Please close this thread if you got the required solution.

Regards,

Jagan.