Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

maverjannet
Valued Contributor

Re: Format number within expression

try

=num('Credit Utilisation (Limit Spent) - '& Sum (Limit-[OTB (excl. oversell)])/Sum (Limit)*100),'#,##0.00%') or Properties

1.PNG

Re: Format number within expression

Guys do you realize that this post is from 2011? They might have already solved the issue.

Just wanted to let you know if you did not already know.

Best,

Sunny

md_anasabbasi
New Contributor III

Re: Format number within expression

Hi Sunny,

     Is there a way to round your number up to the nearest million, e.g. 2,893,754,164 so if I write it in million it should be 2,894M not 2,893M because I want to round up. But everywhere I see they suggest to divide the number by 1 million and add M at the last.

Thanks,

Anas

Highlighted
MVP
MVP

Re: Format number within expression

Ideally, you should have created a new thread for not so-much related topic help.

You can use Ceil() like:   Ceil( <number> , 1000000 ) &'M'