num format

[Chanty4u]

hi,

i hve exp   in text object

ExP; num((count(Def_ID)),'#.#00'))*100

my result is 107994.44444444

Expexted output:  10.79%

how can i achieve in text object?

thanks in advance''

Suresh

[Chanty4u]

no anand....it shwng as % wit same result

[Anonymous]

what about this??

Num((Count(Def_ID)/10000, '##.00%') shared by Sunny

[Kushal_Chawda]

try this

=num((count(Def_ID)),'#.00%')

[Chanty4u]

am using  in text object

=(count(Def_ID) -sum(if(Def_Status='Duplicate' or Def_Status='Withdrawn' or Def_Status='Rejected',1,0))

  /

  num((count(Def_ID)),'#.#000')*100&'%')

[Chanty4u]

that is wrkng but... i need the formuale *100  not .'/'

[Anonymous]

Okay, you need *100

then this?

Num((Count(Def_ID)/1000000, '##.00%')*100

[its_anandrjs]

Share your sample file with expected output.

Regards

Anand

[Chanty4u]

that missing closing bracet ...its wrkng fine

[tresB]

Try with floor(), like:

Floor(count(Def_ID), 0.01) &'%'