Variance Percentages Calculations Dynamically

SundarAnupindi — Thu, 16 Jun 2022 21:36:33 GMT

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?

Re: Variance Percentages Calculations Dynamically

SundarAnupindi — Fri, 17 Jun 2022 03:18:24 GMT

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