Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Percentage formatting

hi,

i have table as follows:

order value1
order value 2total_sales_value
15087

505

6499600
8145700

and i am getting output like:

sales %
469.3
271.6
180

i am using formula as - (order value1+order value2)/total_sales_value*100

here i am getting percentage format as shown in table i.e 469.3% using 12.3% number formatting also using 12% number formatting ans is - 469%.

but actual expected ans is 46.93%

how to solve this condition?

6 Replies
shraddha_g
Partner - Master III
Partner - Master III

use expression as

(order value1+order value2)/total_sales_value

Don't multiply it by 100.

Not applicable
Author

will it give percentage value without multiplying by 100????

shraddha_g
Partner - Master III
Partner - Master III

yes..

shraddha_g
Partner - Master III
Partner - Master III

PFA

Not applicable
Author

Attachment

shraddha_g
Partner - Master III
Partner - Master III

Try now