Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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

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

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.