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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Calculating percentage for each row in a table

Hi everyone,

I'm trying to figure out how to calculate the percentage (=((Sum([CY 2017]) - Sum([Prev.CY 2017])) / Sum([Prev.CY 2017]))) for each row in the table accuractely. Here's a picture for reference.

tables percentages.PNG

As you can see, the numbers aren't accurate. Please help.

10 Replies
vishsaggi
Champion III
Champion III

I believe time for you to share some sample data where you have this issue...