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

[sunny_talwar]

May be you need to divide by 100 instead of multiply by 100

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

[roger_stone]

Try num((count(Def_ID)),'#.#00'))/100

[Chanty4u]

no sunny...its also givng same

[sunny_talwar]

Are you saying that *100 is giving you the same number as /100? or is the formatting is still the same?

[Chanty4u]

No luck.....roger

[its_anandrjs · Accepted solution]

Try this as well

​=num((count(Def_ID)),'#.#00')*100&'%'

[Chanty4u]

the actual formulae....the above mentioned exp is denomenator  that shud be *100

[sunny_talwar]

This seems to be working:

=Num((1079.9444444444/10000), '##.00%')

So may be try dividing by 10000 instead of 100

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

[Anonymous]

share your complete formula buddy..then only we can help you..