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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

How to calculate percentage ??

I have calculate percentage by :

sum(inbound_orders)/sum(actual_receipts_qty)

by my percentage calculation is exceeding 100 ...

How to achevie the percentage value.

Note: I am using pivot table ....I didnt get any relative option on my template...(no option)

and I also tried this expression : =sum(inbound_orders)/sum({1} actual_receipts_qty)

1 Reply
Not applicable

try this

num(sum(inbound_orders)/sum(actual_receipts_qty),'##00%')

see attachement