# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Esteemed Contributor III

## num format

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?

Suresh

Tags (3)
1 Solution

Accepted Solutions
MVP

## Re: num format

Try this as well

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

18 Replies
MVP

## Re: num format

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

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

Contributor III

## Re: num format

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

Esteemed Contributor III

## Re: num format

no sunny...its also givng same

MVP

## Re: num format

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

Esteemed Contributor III

## Re: num format

No luck.....roger

MVP

## Re: num format

Try this as well

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

Esteemed Contributor III

## Re: num format

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

MVP

## Re: num format

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%')

Esteemed Contributor