KPI Percentage with formula in denominator

[Bnm03080]

Hello..

New to QlikSense and BI/Coding overall..

Trying to calculate a percentage based on the below (making it simple using the "1" in the numerator).

1/sum( {$<[Scope vs. Negotiated]= {"*Scope*"},[Manager Name]= {"*Christina*"}, [IL Status]= {"*5*","*4*","*3*","*2*","*1*"}>}[CY Savings 2020] )-sum( {$<[Manager Supplier]= {"*Christina*"}>}[2020 APV Supplier] )

Not sure how to make the percentage calculate properly as the formula within the denominator isn't taking the difference as I would expect, it is taking the second set analysis only and making it a negative number...? 

-sum( {$<[Manager Supplier]= {"*Christina*"}>}[2020 APV Supplier] )

[kaushiknsolanki · Accepted solution]

Try after enclosing your denominator in brackets like below.

1/(sum( {$<[Scope vs. Negotiated]= {"*Scope*"},[Manager Name]= {"*Christina*"}, [IL Status]= {"*5*","*4*","*3*","*2*","*1*"}>}[CY Savings 2020] )-sum( {$<[Manager Supplier]= {"*Christina*"}>}[2020 APV Supplier] ))

[Bnm03080]

Thank you so much! 😃