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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
qliker3
Creator
Creator

Reverse a ratio

so i have this formula a-b/a+b and i get 2 %. I want to get 98 %. How do i do this? 

Labels (7)
1 Solution

Accepted Solutions
MarcoWedel

I guess you mean (a-b)/(a+b) ?

Then your expected result would be

1-(a-b)/(a+b)

or

(2*b)/(a+b)

 

Do you have some sample data/results to verify?

View solution in original post

2 Replies
Chanty4u
MVP
MVP

May be this 

Sum(Sales) / Sum(Total Sales)

MarcoWedel

I guess you mean (a-b)/(a+b) ?

Then your expected result would be

1-(a-b)/(a+b)

or

(2*b)/(a+b)

 

Do you have some sample data/results to verify?