topic Re: Percentage of Expenses from Total Income: SAS VA in SAS Visual Analytics

Percentage of Expenses from Total Income: SAS VA

balraj — Thu, 02 Mar 2017 11:29:15 GMT

Hi Community,

I'm using SAS VA 7.2 my sample data is as follows:

Type ItemName Value

Income Services 25000

Income interest received 46500

Income interest -banks 32000

Expense Transit charges 23000

Expense Internet charges 9000

Expense Audit Fees 6000

Expense Bank charges 11000

How can I calculate Percentage of each Expense from Total Income?

like:

% Transit charges from Total Income=?

% Internet charges from Total Income=? and so on...

Regards,

Balraj

ShivamKS — Thu, 02 Mar 2017 12:57:46 GMT

Is this your requirement?

balraj — Thu, 02 Mar 2017 13:28:14 GMT

Yes Spot on..!!! @ShivamKS,

I've implemented till what you've implemented, was about to update that.

Now I'm struck at this point, let me explain:

let suppose sum percent expenses of income =47.35

where as what i'm trying to achieve is it should be equal to 100% of expenses

i.e., sum percent expenses of income = 100% = Total Expenses %

This is what i'm able to achieve:

ShivamKS — Thu, 02 Mar 2017 14:15:08 GMT

In the pie chart that values are % of total expense and not % of total income, that is why when you total them they give 100%.

They are two different calculations isn't it? Not sure if i am missing something.

ShivamKS — Thu, 02 Mar 2017 14:24:31 GMT

In order to get values same as pie chart like:

The calculation:

balraj — Fri, 03 Mar 2017 05:54:06 GMT

Wow Thank you very much @ShivamKS now I've understood how it is working internally.

And I've also understood that SUM of % of Expense from Total Income will not be equal to 100%, as it is calculating separately for

each group.

Is there any alternate method to achieve the same?

Please share some inputs on this.