Variance Percentages Calculations Dynamically

[SundarAnupindi]

We have 15 to 20 Locations that record Expenses and Income.

The Chart of Accounts calculates the Net Income/Loss accurately.

Recently we had a requirement to calculate the percentage of Expenses/Income as a percentage of Net Income/Loss.

The Net Income/Loss amount is always considered as 100%. 

For Example, if I have $250 as Net Income/Loss for Location # 1 and has Income of Rent as $2000, I want to show the % as 800%

For Example, if I have $900 as Net Income/Loss for Location # 2 and has Income of Rent as $3600, I need to show the % as 400%

The Locations can be selected by the end-users dynamically. 

The SQL Server Database is refreshed daily once. We don't pre-load the percentages recalculated. We want to find them dynamically upon selection. 

How can we perform this? 

[SundarAnupindi · Accepted solution]

I think the following article provided us with the calculations that we are looking for. 

https://community.qlik.com/t5/App-Development/Divide-all-values-by-one-value-from-the-table/td-p/126...