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: 
bazzaonline
Creator
Creator

Script Calculation as Percentage

Hello,

Im trying to divide one figure by another in the load script which works fine, however I want the result to be a percentage not a number. 

How can I do this in the script??

Thank You

1 Solution

Accepted Solutions
sunny_talwar

Force it to be a % by doing =Num(x/y, '#,##0.00%')

Best,

S

View solution in original post

3 Replies
sunny_talwar

Force it to be a % by doing =Num(x/y, '#,##0.00%')

Best,

S

Anonymous
Not applicable

Hi Find attached App with percent calculation

sunny_talwar

My bad, Use this instead: =Num(x/y/100, '#,##0.00%')