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?
