Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
dseelam
Creator II
Creator II

Test object to Percentage

Hello all,


This is my expression =num($(vShipcurrentOnTimeAmtPct),'#,##0%')


this is the result 75,018,045%

I would like to see just 75.0% instead on whole number

Can some body help

Thanks,

Dinesh

Labels (1)
1 Solution

Accepted Solutions
johnw
Champion III
Champion III

Seems likely you're calculating % incorrectly in the variable, in which case fix the calculation, and it will be formatted correctly.

View solution in original post

2 Replies
sunny_talwar
MVP
MVP

Not sure why you get that, but may be divide it by 1000,000,000

=Num($(vShipcurrentOnTimeAmtPct)/1000000000,'#,##0%')

johnw
Champion III
Champion III

Seems likely you're calculating % incorrectly in the variable, in which case fix the calculation, and it will be formatted correctly.